If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Validation I Hope
Data entry project - keeps changing & I am not as up to speed in Excel 2007
Select Data for Major Category - i.e. Appliances, Furniture Sub Category - Appliances would not have a Sub Category - Return value of N/A Furniture has 3 Sub Categories - or N/A Finally Item is linked to Major Category if Sub Category is N/A BUt if Sub Category is not NA - data validation from list If I have confused you - sorry. -- Becky |
#2
|
|||
|
|||
Validation I Hope
See if there isn't something here
http://www.contextures.com/xlDataVal02.html that will help you out. If that's not exactly what you need, check some of her other dependent lists solutions. Hope this gets you going in the right direction. "MarsBars" wrote: Data entry project - keeps changing & I am not as up to speed in Excel 2007 Select Data for Major Category - i.e. Appliances, Furniture Sub Category - Appliances would not have a Sub Category - Return value of N/A Furniture has 3 Sub Categories - or N/A Finally Item is linked to Major Category if Sub Category is N/A BUt if Sub Category is not NA - data validation from list If I have confused you - sorry. -- Becky |
Thread Tools | |
Display Modes | |
|
|