I have a very large data entry set that often has misspellings that the built in spell check is unable to adequately correct.
I have attached a sample spreadsheet with 2 sheets, one for the "fixed" data (where I would like a macro to correct those spellings), and a spell check lookup sheet where I've started to compile a table with all of the incorrect spellings in column A and the correct spelling in column B.
My question is, does anyone have some sample VBA code that can get me started in the right direction to use the spell checker table I've started to search through all of the data entered in the "Fixed" sheet and automatically start replacing any incorrect spellings with the correct spellings?
Thank you in advance for your help!!
Bookmarks