Question about Drop down list

[sspatriots]

I'm curious to know if I have a drop down list that I've been using for a while and then learn that one of the entries in that list is misspelled, if I correct the spelling of that actual drop down list item is there a way to have that automatically correct all of the existing uses of that drop down list selection in the workbook. For example, lets say one of the drop down selection items is the person's name "Deborah". Then I later learn that it should have been spelled "Debra". So I go to my drop down list and correct the spelling. Other than going through the workbook and doing a "Find and Replace" to offer the correct spelling of the name throughout, I was wondering if there is an easier way to just have these values automatically update immediately when I changed the value in the drop down list. I hope this makes sense, just trying to see if there is something that can be used in lieu of "Find and Replace".


Thanks, SS

 

[awoohaw]

There is an option in the Find and Replace Dialog to "REPLACE ALL" with one click. Is this something you don't want to do?

If the list is used in other formulas the other formulas would automatically update when you replace all just in that column.

 

[sspatriots]

There is an option in the Find and Replace Dialog to "REPLACE ALL" with one click. Is this something you don't want to do?

If the list is used in other formulas the other formulas would automatically update when you replace all just in that column.

Actually, I did use the "Replace All" option. I was just wondering if there was a more dynamic means of having all of the previous drop-down selections automatically changing whenever the list was updated. All of the uses on my worksheet were selected by a user from the drop-down list. Thanks, SS

 

[RoryA]

No, there is no link maintained between the DV list and the values actually selected in the cells unfortunately.