Can I set up sublists under Data Validation

[Guest]

My list is getting too long and I wanted to see if I can shorten it by
cresting subcategories. Another alternative is if there is a way to select a
list based on critera, if the value is one, list A is displayed. otherwise
List B

 

[Tom Ogilvy]

See Debra Dagleish's pages on this:

http://www.contextures.com/xlDataVal02.html

 

[Guest]

EXCELLENT - This is exactly what I needed! Thanks for your help.

Joan