Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Data Validation Lists
Hoping someone can help me here..
I have a spreadsheet whereby I have a Column called 'Primary Caetgory' and a second column called 'Secondary Category'. I have a Data Validdation list drop down for the primary category which lets you choose the cell contents from a list on another worksheet. What I want to be able to do is choose the primary category from the drop down list, then have that narrow down the drop down list on my secondary category based on the what the primary category is. for example: In cell A1, the drop down list might contain, 3 choices.. say Dogs, Cats or People. I choose People. Then in the next column, I want a similar drop down list, which looks up all the avavilable options (secondary categories) for people from the other worksheet. eg. Female, Male. I've tried the long way, assigning names to each range, then using IF statements for data validation conditions, but it's limited to 6 nested IF's, and doesn't seem to be the best approach. Any help would be greatly appreciated. Thanks Cameron_S |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Data Validation Lists
There are instructions here for dependent data validation lists:
http://www.contextures.com/xlDataVal02.html Cameron_S wrote: Hoping someone can help me here.. I have a spreadsheet whereby I have a Column called 'Primary Caetgory' and a second column called 'Secondary Category'. I have a Data Validdation list drop down for the primary category which lets you choose the cell contents from a list on another worksheet. What I want to be able to do is choose the primary category from the drop down list, then have that narrow down the drop down list on my secondary category based on the what the primary category is. for example: In cell A1, the drop down list might contain, 3 choices.. say Dogs, Cats or People. I choose People. Then in the next column, I want a similar drop down list, which looks up all the avavilable options (secondary categories) for people from the other worksheet. eg. Female, Male. I've tried the long way, assigning names to each range, then using IF statements for data validation conditions, but it's limited to 6 nested IF's, and doesn't seem to be the best approach. Any help would be greatly appreciated. Thanks Cameron_S -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Data Validation Lists
Thank you very much.. I did find this document shortly after posting, and it
explained it VERY well.. Problem solved. Thanks again. Cameron_S "Debra Dalgleish" wrote in message ... There are instructions here for dependent data validation lists: http://www.contextures.com/xlDataVal02.html Cameron_S wrote: Hoping someone can help me here.. I have a spreadsheet whereby I have a Column called 'Primary Caetgory' and a second column called 'Secondary Category'. I have a Data Validdation list drop down for the primary category which lets you choose the cell contents from a list on another worksheet. What I want to be able to do is choose the primary category from the drop down list, then have that narrow down the drop down list on my secondary category based on the what the primary category is. for example: In cell A1, the drop down list might contain, 3 choices.. say Dogs, Cats or People. I choose People. Then in the next column, I want a similar drop down list, which looks up all the avavilable options (secondary categories) for people from the other worksheet. eg. Female, Male. I've tried the long way, assigning names to each range, then using IF statements for data validation conditions, but it's limited to 6 nested IF's, and doesn't seem to be the best approach. Any help would be greatly appreciated. Thanks Cameron_S -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Data Validation Lists
You're welcome. Thanks for letting me know that it helped.
Cameron_S wrote: Thank you very much.. I did find this document shortly after posting, and it explained it VERY well.. Problem solved. Thanks again. Cameron_S "Debra Dalgleish" wrote in message ... There are instructions here for dependent data validation lists: http://www.contextures.com/xlDataVal02.html Cameron_S wrote: Hoping someone can help me here.. I have a spreadsheet whereby I have a Column called 'Primary Caetgory' and a second column called 'Secondary Category'. I have a Data Validdation list drop down for the primary category which lets you choose the cell contents from a list on another worksheet. What I want to be able to do is choose the primary category from the drop down list, then have that narrow down the drop down list on my secondary category based on the what the primary category is. for example: In cell A1, the drop down list might contain, 3 choices.. say Dogs, Cats or People. I choose People. Then in the next column, I want a similar drop down list, which looks up all the avavilable options (secondary categories) for people from the other worksheet. eg. Female, Male. I've tried the long way, assigning names to each range, then using IF statements for data validation conditions, but it's limited to 6 nested IF's, and doesn't seem to be the best approach. Any help would be greatly appreciated. Thanks Cameron_S -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Lists | Excel Worksheet Functions | |||
Excel -- Data Validation -- Create Dependent Lists | Excel Worksheet Functions | |||
Linked Lists / Data Validation - Excel 97 | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Excel data validation multiple lists | Excel Programming |