Comparison between two excel sheet
Solved/Closed
Related:
- Comparison between two excel sheet
- How to take excel sheet screenshot - How-To - Excel
- How to copy data from one excel sheet to another - How-To - Excel
- Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
- How to change language in excel sheet shortcut key - Guide
- Vba code to compare two excel sheets and copy differences ✓ - Forum - Excel
2 replies
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
I have given a macro below
when do you want this macro to be invoked( under what event ) or do you want to invoke th macro periodically
the macro is
Please rememner that only if A1 or any other cells in column A of sheet 1 is same as the entry in the same address in shseet2 that cell in sheet 1 will be red. suppose the same entry in any cell in sheet1 is found in some other address in sheet 2 the original cell in sheet 1 wil Not be red.
when do you want this macro to be invoked( under what event ) or do you want to invoke th macro periodically
the macro is
Sub test()
Dim r As Range, c As Range, j As Integer, k As Integer
With Worksheets("sheet1")
Set r = Range(.Range("A1"), .Range("A1").End(xlDown))
r.Cells.Interior.ColorIndex = xlNone
For Each c In r
j = c.Row
k = c.Column
If c = Worksheets("sheet2").Cells(j, k) Then
c.Interior.ColorIndex = 3
End If
Next c
End With
End Sub
Please rememner that only if A1 or any other cells in column A of sheet 1 is same as the entry in the same address in shseet2 that cell in sheet 1 will be red. suppose the same entry in any cell in sheet1 is found in some other address in sheet 2 the original cell in sheet 1 wil Not be red.
