It seems like you could either:

1. Do a search and replace on the relevant area in sheet2 anytime you
make a change to the name list on sheet1.
or
2. Link the names on sheet2 to the validation list on sheet1 through a
lookup. That way the names will be dynamically synchronized with the
list and the manual search and replace would be unnecessary.
or
3. Have code in triggered by a workbook event to automatically trigger
the search and replace in the other sheet. This would be feasible,
but, a little tricky since you would have to keep track of what the
name was before you changed, so the code would know what to replace.

Good luck.

Ken
Norfolk, Va

On Dec 30, 9:38*am, "Arnold" wrote:
I'm accustomed to databases, in which this is easy. After browsing this
group, it appears that Excel cannot do this?

I have ranges on Sheet1, and data validation list boxes on Sheet2 pull
in the data from Sheet1.

The data are only names, like firstname and lastname. *I know that a
user will, by accident, misspell a name in Sheet1, then set a bunch of
cells in Sheet2 with the misspelled name, then realize it, then correct
the name in Sheet1, then go to Sheet2 and say, "Hmmm, I thought I
corrected the spelling of that name."

Is there a way to automatically update the values? *FYI--I expect that
the majority of misspelled names will only be a letter or two off,
exclude a period, etc.--not be an entirely different name.

Thanks for helping if you can.

Arnold