Updating Source List

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

Guest

We are using Excel 2003. My spreadsheet is using a data validation list. If I
change an item in a data validation source list, the worksheet still shows
previously selected items. How can this be updated without manually going
back and re-selecting the new source data?
 
Are you saying that you want to change cells that previously had
aaa
to
bbb
because you changed the data validation list from aaa to bbb
 
if something in the source list was titled johndoe and i changed it to read
johnd. anywhere there is a validation drop-down it still reads johndoe even
though i changed the source to read johnd.
 
debra......thank you for that. i downloaded it, and i see how it works. how
do get that macro into my existing spreadsheet? or can i? i'm not an
advanced user and don't use many macros, and even fewer codes.
 
Try this on a copy of your workbook:

In the sample file, right-click on the Lists worksheet tab, and choose
View Code
Copy the code
Go to your workbook, right-click on the sheet tab where your list is
stored, and choose View Code.
Paste the code there.
In the code, change the sheet names and the range name for the list, to
match the names in your workbook.
The code replaces values in column B on the Data sheet, and you should
change that if your data validation is in a different column.
 
Back
Top