Compare Macro

Hi,

I want a VB code with which I can compare two excel files having the same data. It may have multiple columns and rows but I want to get the unmatched values from both the sheets to be pasted in a new file.

There is also one problem, as few columns may be not present in both sheets or may be not sorted properly with the same order.

---------- Post added at 11:43 PM ---------- Previous post was at 11:43 PM ----------

Any help would be very appreciated

Thank you

Here are the example sheets...