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.

 

[Guest]

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

---