| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Using 2 Lists
I want to be able to drive the selection by Data Validation Lists from the
selection of one list - eg category.....following selection of an item in that list.....the secondary list is populated with valid sub-categories only for that category.....is there anyway to do this using validation lists or is another approach needed ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation - Using 2 Lists
I think Dependent Lists will meet your requirements.
See Debra Dalgleish's website for instructions: http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "scott56hannah" wrote: I want to be able to drive the selection by Data Validation Lists from the selection of one list - eg category.....following selection of an item in that list.....the secondary list is populated with valid sub-categories only for that category.....is there anyway to do this using validation lists or is another approach needed ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Data Validation lists display bottom vs top | Excel Discussion (Misc queries) | |||
| Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
| Font size in data validation drop down lists | Excel Discussion (Misc queries) | |||
| 6 Data Validation lists depending on 1 cell value | Excel Discussion (Misc queries) | |||
Linear Mode
