Thanks for all your replies. Happy new year.


Debra Dalgleish wrote:
There's a sample file here that uses programming to update changed items:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0022 - Update Validation Selections'

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.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html