Refresh existing data when changed in data validation list

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



"problem girl" <problem [email protected]> wrote in message
news:[email protected]...
>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