First of all, my heartiest congratulations and thank you to the great Kioskea team that who have a mine of excellent solutions already available in their Forum and if by change not available then it just ask, it is with us in no time.
I have have went through tremendous macros to compare two sheets and they have awesome results.
But I have little tweak in my data for the comparison.
I have two sheets [Before] and [After] containing data in A:AZ columns.
Please note that position of these column names [headings] are same in both the sheets.
First column contains an Id that is key to match both sheets.
Please note that the count of rows are different in both the sheets. It is possible that either an Id may be missing in the either sheets or may be appearing more than once.
My challenge is to compare both the sheets [Before] and [After] based on Id in Column A, and
a. Either highlight the cells that are [Not matching] in a column
b. Display the mismatched results [highlighted cells with entire affected Row] in third sheet [Results]
Don't know I may be very demanding, but this will help me a lot to provide assistance to my team and seniors.
Appreciate to helping we non Tech people all around the world.