View Single Post
  #1  
Old March 23rd, 2011, 06:30 AM
narendran narendran is offline
Member
 
First recorded activity by OfficeFrustration: Mar 2011
Posts: 2
Default Old Value not clearing in drop down list

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