Lists Data Validation

[Merlin54k]

How can I set up data validation lists to work off of each other?

For example, in column A you have your drop down lists with certain options. Depending on your selection in column A cell A4, you will have selections available in B4 that refer only to the selection in cell A4's grouping.....


Many thanks,
Merlin

[BigBas]

You will have to use named ranges.

this link should help:

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

Let me know if you have any more questions.

[Merlin54k]

Big Bas,

Thanks for your quick reply and assistance. Your help was on the money and I am golden!!!


Muchas Gracias!
Merlin

[BigBas]

De nada. Glad I could help.