Can I set up sublists under Data Validation
 

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

Can I set up sublists under Data Validation
 

See Debra Dagleish's pages on this:

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

--
Regards,
Tom Ogilvy

"Consulting Joan" <Consulting wrote in
message ...
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

Can I set up sublists under Data Validation
 

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

Joan

"Tom Ogilvy" wrote:

See Debra Dagleish's pages on this:

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

--
Regards,
Tom Ogilvy

"Consulting Joan" <Consulting wrote in
message ...
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