I don't think we will be able to guess what you did, the permutations are
enormous. What exactly did you do, what formulae, data etc.?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"premierbmwagve" wrote in message
...
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 ?"