Thankyou . the above post was really helpful.
i have another doubt ..

i have added the dropdown in the field required . now i need to know how to add another dropdown relating to the 1st dropdown box that i already added .


like for e.g., A1 have the drop down stating countries list .it have some 50 countries.
now i need next column B1 to have states for the simultaneous country.
Say if i select India in A1 i should get options only for states in India (i.e its should have only the states in india . i should not have any states in other countries).. and if i select other countries i should have option to select states only from that particular country.

could you please reply ..

thank you