Creation Of Interconnected Drop Down Lists using Data Validation

[mksreekumar58]

Hi All,


I have a requirement. Actually i want to create 3 drop down lists. First one for selecting state, Second one for selecting district and third one for selecting city. If i select "state 1" from my first list, i want "districts" of state 1 in the second drop down list and cities corresponding to the selected "district" in the third drop down list. Anybody please help me to do it.


Thanks in advance

Sreekumar