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