Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
validation selection
Having read the following posts - I thought it would be easy to have 5
categories with up to 30 items in each sub category. Please help... the first column and categories work fine, but the sub-set does not. Some rows do not display a menu and if they do they are not the corresponding items. I have changed names etc to no avail. I cannot see what I am doing wrong.... "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 ?" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validation list - filter based on selection | Excel Worksheet Functions | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
How can you jump to a selection in a validation drop-down? | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Data Validation list selection question | Excel Worksheet Functions |