Thanks for the reply but i have some more doubt. how can you add a third dependent list to this.
For example i have columns with headings continent, country, state & city. if i select Asia as the continent in cell A1, i need to get a dropdown list in cell B1 with asian countries list in the country column i.e. India,China etc.. if i select India then i need to get the states of the country(India) in cell C1 i.e. New Delhi, Kerala etc.. and when i select a state in cell C1 i need to get a drop down list with the cities in the state for example cochin, kollam etc..
can you please provide me the solution
Can you please provide me the solution.....
Having said that, you solution would be same way, you just expand the design to take into consideration
In that, on change of col A, list of col B would be populated. In you case, on change of col A, list of col B would be populated and list for col C wiped out. On change of col B, list of col C would be repopulated