Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependent Validation
I want to have four sets of drop down menus. You would choose Menu 1, and
the options for Menu 2 are based on what you chose for menu 1, and the option for Menu 3 are based on the choices for Menu 1 and 2, and Menu 4 is based on the options chosen for Menus 1,2, & 3. I would also like the Menus 2 through 4, to only list uniques names. There are too many options to create seperate lists and do an Indirect to a range name. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dependent Validation
http://www.contextures.com/xlDataVal13.html
check out this site it all the instruction for what you are trying to accomplish I am really a morom and was able to figure it out usign this site "Paul" wrote: I want to have four sets of drop down menus. You would choose Menu 1, and the options for Menu 2 are based on what you chose for menu 1, and the option for Menu 3 are based on the choices for Menu 1 and 2, and Menu 4 is based on the options chosen for Menus 1,2, & 3. I would also like the Menus 2 through 4, to only list uniques names. There are too many options to create seperate lists and do an Indirect to a range name. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation-Dependent Lists | Excel Discussion (Misc queries) | |||
Dependent DropLists - Using Validation | Excel Worksheet Functions | |||
Data validation dependent lists | Excel Discussion (Misc queries) | |||
Validation of cells who is dependent on each other | Excel Discussion (Misc queries) | |||
Data Validation & Dependent Lists | Excel Worksheet Functions |