How to use a macro to check data in 2 work sheets [Solved/Closed]

Posts
2
Registration date
Monday October 9, 2017
Status
Member
Last seen
October 10, 2017
-
Hi team
I have 2 work sheets with thousands of data.
I need a macro to compare data in these 2 work sheets and show the result(matching or not matching)

Please provide me qode for this
See more 

1 reply

Best answer
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1566
1
Thank you
Here is a good start:
Compare Values of a Range

                                Dim firstrange
Dim Logictest
Logictest = "some word or value"
If (Range(firstrange).value = Logictest) then
'some routine here
End If


Have fun!

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 5776 users have said thank you to us this month