insert a line on condition

[jinvictor]

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.

[Max]

"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
---