check debra's site

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

--

Gary Keramidas
Excel 2003


"Santa" wrote in message
...
Hi,

I have a Data sheet where the data is available as shown below.

Code Name Country code City Id City Name
AX Aland Islands AS 2974 Aaheim
AL Albania DZ 273 Aaiun
DZ Algeria AS 6289 Aalborg
AS American Samoa AD 1955 Aalborg Gronlandshavn
AD Andorra AD 1954 Aalborg Osthavn

I would like to create two drop down controls - the first one will list
all
the countries from a range named "Country". The user will select a country
from this drop down and based on the country code the second dropdown
should
list all the cities from a range named "City".

Basically, I would like the two dropdowns behave like a master/details
controls with the help of the CountryCode.

Appreciate your help.