about droplist

[jinvictor]

4858

thanx!!

+-------------------------------------------------------------------
|Filename: sample.JPG
|Download: http://www.excelforum.com/attachment.php?postid=4858
+-------------------------------------------------------------------

 

[Zygan]

attached is a copy of the workbook which hopefully will help


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4860 |
+-------------------------------------------------------------------+

 

[jinvictor]

attached is a copy of the workbook which hopefully will help

its helpful, but i want is: a1 is droplist with cities data, b1 i
droplist with countries data, when you choose usa in b1, a1 is usa'
cities droplist so you can choose cities, when you choose australia i
b1, a1 shows australia's cities for you to choose, but when b1 i
blank, a1 is china's cities' droplist.

than

 

[Zygan]

try this one out

is this what your after?


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4861 |
+-------------------------------------------------------------------+