| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
If spelling of a word in a DV range changes, can values previously selected be updated?
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 |
| 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 | |||
![Arnold[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
