Refresh existing data when changed in data validation list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to refresh my existing values when i change the data validation list .
Is it possible??? For example if my list contained message1 and i changed it
to message2 , the changed should be reflected whereever i had selected
message1 from the list
 
Problem Girl,

Why not select the entire sheet, and to a global replace of Message1 with
Message2? That should change the values both in your data validation list
(use a worksheet range for that rather than a typed-in list from the DV
dialog) and it will work. Excel ignores changes made to cells with DV when
they are made through the replace dialog.

HTH,
Bernie
MS Excel MVP
 
Back
Top