about droplist

**jinvictor** · 06-07-2006, 06:29 AM

**Zygan** · 06-07-2006, 06:40 AM

attached is a copy of the workbook which hopefully will help

**jinvictor** · 06-07-2006, 06:59 AM

Originally Posted by Zygan

attached is a copy of the workbook which hopefully will help

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

thanx