what can i do if i want different droplist in a same column when i
choose different condition.
for example:

a1 australia, china, england

b1 drop list with different cities in that country.

when i choose australia in a1, then droplist in b1 only shows australia
cities.
when i choose china in a1, only chinese cities droplist show in b1
.....

thanx


--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile: http://www.excelforum.com/member.php...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=548248