Report

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

Ask a question MadhaviLakshmi 2Posts Monday October 9, 2017Registration date October 10, 2017 Last seen - Last answered on Oct 9, 2017 at 04:52 PM by ac3mark
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
Helpful
+1
plus moins
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!
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!