Old Value not clearing in drop down list

[narendran12]

Dear Members,

I have two drop down list in the Excel sheet. say Country and State. If i choose value from Country, automatically respective state should be populated.

I have achieved this through creating the name manager and use that in the Data validation.

Issue here is, when i select the value from country, old value in the state still shows up in the field & correct value shows in the drop down. How to clear the old value in the state field ?

Can we achieve this through the excel sheet function itself without macros/scripts ? Appreciate your quick response.

PS: am using Excel 2007

 

[pedie]

I think Dynamic Range list can help if your list is growing or changes frequently. Try <<< Link

 

[RoryA]

You have to use code - is that a problem?