insert a line on condition
 

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

insert a line on condition
 

"jinvictor" wrote:
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 chose other
countries in a1, nothing change.

Perhaps in A2, something like:
=IF(A1<"china","",<your function)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---