Compare two documents or sheets side by side

[Alex Sanchez]

Hello there,

Is there a way to compare two documents or sheets side by side and have excel tell you or highlight a cell if it doesn't match with the other cell in the other docoment or sheet.

Thanks,

Alex

 

[HalfAce]

Hello Alex Sanchez, welcome to the board.
There are likely quicker ways to do this (most especially if these are really huge data sets)
but this is about as robust a method as I can think of.

Sub CompareSheets()
Dim c1 As Range

If Sheets("Sheet1").UsedRange.Cells.Count <> _
   Sheets("Sheet2").UsedRange.Cells.Count Then
     MsgBox "These sheets have different amounts of data. They do not match.", , "Different Range Sizes"
     Exit Sub
End If

For Each c1 In Sheets("Sheet1").UsedRange
  If Not c1.Value = Sheets("Sheet2").Cells(c1.Row, c1.Column).Value Then
    MsgBox "cell " & c1.Address(0, 0) & " does not match in both sheets.", , "Non Match Found"
    With c1.Font
      .ColorIndex = 3
      .Bold = True
    End With
  End If
Next
End Sub

Hope it helps.