Double Drop-Down Validation in Excel 2007



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