A Macro For Various Data Corrections From List

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.

Example:

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.

Re: A Macro For Various Data Corrections From List

forum.ozgrid.com/index.php?attachment/45396/Great!! Thank you for your optimism.
I hope the attachment works.

Collumn A(List Sheet) is incorrect. Collumn B(List Sheet) is the intended value.
I need to search a different collumn in a different sheet, collumn I(Sheet 1-Etc...) for values from Collumn A(List Sheet) across multiple sheets. When found, I need the corrected term from Collumn B(List Sheet) to be inserted into Collumn M(Sheet 1-Etc...)

Thanks so much for your help.forum.ozgrid.com/index.php?attachment/45393/

Re: A Macro For Various Data Corrections From List

You are awesome and you just saved me weeks of time. Thank you so much!!

Re: A Macro For Various Data Corrections From List

I need this to function exactly as it is currently with one addition. If it finds any cell in collumn i(ws-<>"List Sheet") any cell from Column (i) that that MATCHES the data from Column B(ws-List Sheet), I want it, instead of filling the cell in Column M with the contents form Column B(ws-List Sheet) like it does now, I need it to erase the contents in Column M and input an EMPTY cell..only for the ones that Match the data from Column B.

Basically I just need to figure out how to add the phrase "If does match Column B from ws-"List Sheet" then return an empty cell into Column M(every sheet not equal to "List Sheet")".

Sub Variables()
Application.ScreenUpdating = False
Dim a, i As Long, rCell As Range, ws As Worksheet
a = Sheets("List Sheet").Range("A1").CurrentRegion.Value
With CreateObject("Scripting.Dictionary")
.comparemode = 1
For i = 2 To UBound(a, 1)
If Not .exists(Trim(a(i, 1))) Then .Item(Trim(a(i, 1))) = Trim(a(i, 2))
Next
For Each ws In Worksheets
If ws.Name = "SAP_EQ_Master" Then
For Each rCell In ws.Columns("I").SpecialCells(2, 2)
If .exists(Trim(rCell.Value)) Then rCell.Offset(, 4) = .Item(rCell.Value)
Next
End If
Next
End With
Set rCell = Nothing
Set ws = Nothing
Application.ScreenUpdating = True
End Sub

Does this makes sense?

Re: A Macro For Various Data Corrections From List

Thanks for getting back so quickly.
I tried the code and it ran without errors but did not change the matched data cells(Matching Column B with Columns i). It didn't empty Columns (M) if Columns (i) matched Column (B).

Re: A Macro For Various Data Corrections From List

Thank you. I'd forgotten I used that for another project.
I corrected that and it ran fine but now it is completely clearing out Column M from all worksheets other than "List Sheet". It didn't empty Columns (M) ONLY IF Columns (i) matched Column (B).

Re: A Macro For Various Data Corrections From List

Like. A. Charm.

Thanks again!!