Conditional Validation

[mattmclaughlin]

Hi! I was wondering if there is a way to do conditional drop-down
lists through validation. For example, in the first cell the user
chooses the State (using a validation list to restrict the selections).
Then in the next cell I want to use validation that presents a
drop-down list of all the counties in the State instead of having to
choose from all the counties in the US.

Thanks,
Matt

 

[Trevor Shuttleworth]

Try this:

http://www.contextures.on.ca/xlDataVal13.html

Debra Dalgleish's Contextures site has lots of useful examples

Regards

Trevor

 

[Puppet_Sock]

Hi! I was wondering if there is a way to do conditional drop-down
lists through validation. For example, in the first cell the user
chooses the State (using a validation list to restrict the selections).
Then in the next cell I want to use validation that presents a
drop-down list of all the counties in the State instead of having to
choose from all the counties in the US.

Eventually, if you get enough of this sort of thing in an Excel
workbook,
you should think about switching over to a database. If it's only a
few,
sure, leave it as Excel. But if you start to find you have many, then
there are constructs in Access, for example, that are designed to
make such tasks easy.
Socks

 

[mattmclaughlin]

Thanks - Got it to work using this example!

huge help!!