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.

check debra's site

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

--

Gary Keramidas
Excel 2003


"Santa" <(E-Mail Removed)> wrote in message
news:0CB52884-D4FE-4FED-A871-(E-Mail Removed)...
> 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.
>