insert a line on condition

Giganews Newsgroups
Subject: insert a line on condition
Posted by:  jinvictor (jinvictor.28vhra_1149416400.694@excelforum-nospam.com)
Date: Sun, 4 Jun 2006

a1 is droplist which contain information,(china,australia.....)
i want to do is:
every time i choose china in a1, there will be a pre set line insert in
a2,(that line got all the functions i pre setup), but when i chhse other
countries in a1, nothing change.

cheers.

--
jinvictor
------------------------------------------------------------------------
jinvictor's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34099
View this thread:http://www.excelforum.com/showthread.php?threadid=548257

Replies