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.

Double Drop-Down Validation in Excel 2007
 

Check out the below link from Debra on "Data Validation -- Dependent
Dropdowns from a Sorted List "

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

If this post helps click Yes
---------------
Jacob Skaria


"Chey" wrote:


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.