I have a list of incorrectly spelled or formatted data and also a list of that data corrected. Two lists on one sheet.
I need to search across multiple other sheets for the "incorrect data" and place the correlating "corrected" cell from the corrected list, into the cell next to it.
Collumn I(Sheet1) is incorrect. Collumn M(Sheet1) is correct.
I need to search a different collumn, collumn "B" for values from Collumn I(Sheet1) across multiple sheets for each individual value of Collumn I(Sheet1).. and when found, I need the corrected term from Collumn M(Sheet1) to be inserted into Collumn C(Multiple Sheets).
I could really use the help, I've been on this for days doing it individually and without a macro it may take weeks.