Double Drop-Down Validation in Excel 2007

C

Chey

Is there a way to make the drop-down list that appears for cell validation
conditional on the value in another dropdown cell? Suppose one cell contains
a drop-down list containing categories like Country, State and City. I want
to be able to select the country in dropdown list n 1 and automaticaly
displays only the states that belongs to the selected country on dropdown
list n 1 in the dropdwon list n2. As well as when I choose the state
(dropdown list n 2) it will anable the cities that belong to that state in
drop down n3.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Lists 2
How to delete a drop down box in Excel 2007 1
How do i show the drop down arrow for a list in Excel 1
Size of drop down in validation list 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation Error 1
Drop down list indicator 8
Dependant drop-down lists allowing invalid entries 3

Top