Hi Guys,

Can anyone help me with the macro to compare two sheets which will give me below 4 results

New Row added
Row deleted
Row modified
Row is same as previous sheet

I tried recording macro using vlookup and sha1 hash; however it won't give me results based on deleted and newly added rows.

Any help regarding this is greatly appreciated.

Thank you