Forum Discussion
msal4434
Occasional Contributor
Hi Shankar,
Thank you for your solution.
Need one more solution.
-Read A1(Column1) from Sheet1 and find A1(Column1) in Sheet2.
If there is a match than Read G1(Column 7) from Sheet 1 and F1(Column 13) in Sheet2 and check if they match or not?
Thanks and Regards
Sal
shankar_r
8 years agoCommunity Hero
In this case, you just change the Column Number in the below highlighted code.
If(WS_A.Cells(iR,1).Value = WS_B.Cells(iR,1).Value) Then If(WS_A.Cells(iR,4).Value = WS_B.Cells(iR,5).Value) Then Log.Message("Value matched " & WS_A.Cells(iR,1).Value) WS_A.Cells(iR,1).Interior.ColorIndex = 0 Else WS_A.Cells(iR,1).Interior.ColorIndex = 3 End If Else WS_A.Cells(iR,1).Interior.ColorIndex = 3 End If
Related Content
Recent Discussions
- 2 days agoGane195