Hello every body
How can I compare two different sheets or ranges in same files or different files.
Hello every body
How can I compare two different sheets or ranges in same files or different files.
Last edited by Farooque; 11-03-2011 at 02:00 PM.
There should be some common field or fields on the basis of which you can compare. Probably if you attach a sample file(s), i can help better.
Dear
Both sheet having same format, only data changed
sample is attached
So as per the attached files, what do you want to compare? Each and every data? Also, if we find a mismatch, what should be done?
Sorry for too much delay, I want to check changes (if any) in todays sheet comparing with yesterdays sheet. Todays sheet may highlight the changes in a seperate sheet or any other function which shows the changes
Waiting your useful feedback
Thanks
This code brings out the differences between Summery and Summery (2). The differences are highlighed in the Results tab. Is this what you are looking for?
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks