Old Value not clearing in drop down list
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