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 ?"