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

Report
Posts
2
Registration date
Monday October 9, 2017
Status
Member
Last seen
October 10, 2017
-
 Blocked Profile -
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

1 reply


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!
1
Thank you

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

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!