How can I shortlist cities based on the country selected in Excel
 

Column A contains all country names while column B contains all cities. I
want to create drop down lists by using data validation. When someone chooses
a particular country in column A, only shortlist cities in column B will be
displayed. How can it be done?

Take a look at this:

http://contextures.com/xlDataVal02.html

Biff

"Steve" wrote in message
...
Column A contains all country names while column B contains all cities. I
want to create drop down lists by using data validation. When someone
chooses
a particular country in column A, only shortlist cities in column B will
be
displayed. How can it be done?