Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation list
Hi
I have a data validation drop down list which looks up data from a list of tables. What I need is the next cell to to show a dropdown list based on the selection of the first drop down. ie: 1st List A B C A Blue Mon Jan B Green Tues Feb C Yellow Wed Mar the 1st drop down has a list of A,B,C and if B is selected then the 2nd drop down list displays Mon,Tues,Feb then this selection would be used to do look ups. Thank You |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation list
http://www.contextures.com/xlDataVal02.html
-- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Crispy" wrote in message ... Hi I have a data validation drop down list which looks up data from a list of tables. What I need is the next cell to to show a dropdown list based on the selection of the first drop down. ie: 1st List A B C A Blue Mon Jan B Green Tues Feb C Yellow Wed Mar the 1st drop down has a list of A,B,C and if B is selected then the 2nd drop down list displays Mon,Tues,Feb then this selection would be used to do look ups. Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
drop-down list validation won't allow a different worksheet | Excel Worksheet Functions | |||
Expanding Data validation from List | Excel Discussion (Misc queries) | |||
validation list with drop down list of options?? | Excel Worksheet Functions | |||
list validation using list validation... | Excel Worksheet Functions |