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 ..
Keep Up with TechRepublic