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 ?