Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If spelling of a word in a DV range changes, can values previously selected be updated?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
Excel changes spelling of word | Excel Worksheet Functions | |||
Macro to concatenate previously selected cells | Excel Programming | |||
Clearing what you have previously selected | Excel Programming | |||
Selection the previously selected cell | Excel Programming |