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

MadhaviLakshmi 2 Posts Monday October 9, 2017Registration date October 10, 2017 Last seen - Oct 9, 2017 at 04:03 AM - Latest reply: ac3mark 9361 Posts Monday June 3, 2013Registration dateModeratorStatus May 25, 2018 Last seen
- 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
See more 

Your reply

1 reply

Best answer
ac3mark 9361 Posts Monday June 3, 2013Registration dateModeratorStatus May 25, 2018 Last seen - Oct 9, 2017 at 04:52 PM
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!

Thank you ac3mark 1

has helped 2146 users this month

Respond to ac3mark