Supp cell-A1 has a list box with 3 options - America,UK,India.Now if i choose
America from that list then it should show me the cities of America in a list
box in cell no B1..Same way if i choose UK then in cell B1, it should show
the cities of UK .

Please help!!

"Charlie" wrote:
Supp cell-A1 has a list box with 3 options - America,UK,India.Now if i choose
America from that list then it should show me the cities of America in a list
box in cell no B1..Same way if i choose UK then in cell B1, it should show
the cities of UK .

Try Debra's page at:
http://www.contextures.com/xlDataVal13.html
Data Validation -- Dependent Dropdowns from a Sorted List

Another good source is Bob Phillips':
http://www.xldynamic.com/source/xld.Dropdowns.html
Dynamic Dependent Dropdowns

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Hello Charlie
The trick is to use Data Validations Lists and use "related names" for them.
Input your country names starting in A1, define a name = Countries
Place your cities in three different areas of your workbook (starting in B1
for America, C1 for India and D1 for Uk) and
name each list of cities using for prefix the country name used in your list
of countries ie:
AmericaCities refers to the range of cities in America
IndiaCities refers to the range of cities in India
UkCities refers to the range of cities in Uk
Create a Data Validation list for the list of countries and use the name
"Countries" as the source range.
Create a Data Validation list for the list of cities and use this formula in
the Source range :
=INDIRECT($A$8&"Cities")
Where in this example A8 contains the country chosen in your first list.

HTH
Cordially
Pascal



"Charlie" a écrit dans le message de
news: ...
Supp cell-A1 has a list box with 3 options - America,UK,India.Now if i
choose
America from that list then it should show me the cities of America in a
list
box in cell no B1..Same way if i choose UK then in cell B1, it should show
the cities of UK .

Please help!!