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?