Previous Topic Next Topic

How to use a macro to check data in 2 work sheets

Solved/Closed
MadhaviLakshmi Posts 1 Registration date Monday October 9, 2017 Status Member Last seen October 10, 2017 - Updated on Oct 9, 2017 at 02:30 PM
 Blocked Profile - Oct 9, 2017 at 04:52 PM
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
Related:

1 response

Answer 1 / 1
Blocked Profile
Oct 9, 2017 at 04:52 PM
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