Refresh existing data when changed in data validation list

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula and Data Validation parallely 1
label refresh 1
Excel 2007-programming macros that apply to data validation 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation List (conditional) 2
Data Validation 1
Data Validation mystery 2
Possible Indirect query 1

Top