How can I modify the VBA code to compare and match data between the worksheets in my workbook?

[umgbemena]

I need the VBA code to look through the data in my worksheets (contained in a workbook) and compare the data and match them where there are mis-matches between similar data contained in the worksheets.

Sub CompareSheets()
Dim rngCell As Range
 
For Each rngCell In Worksheets("SheetName1").UsedRange

    If Not rngCell = Worksheets("SheetName2").Cells(rngCell.Row, rngCell.Column) Then
        rngCell.Interior.Color = vbYellow
    End If

Next rngCell

End Sub

 

[Joe4]

Try this:

Sub CompareSheets()

Dim rng As Range
Dim rngCell As Range
 
Set rng = Worksheets("SheetName1").UsedRange
For Each rngCell In rng

    If Not rngCell = Sheets("SheetName2").Cells(rngCell.Row, rngCell.Column) Then
        rngCell.Interior.Color = vbYellow
    End If

Next rngCell

End Sub