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...o&userid=34099
View this thread: http://www.excelforum.com/showthread...hreadid=548257