How to compare 2 sheets data on a single sheet through VBA Codes?

Pradeep,

I started writing a solution for you and finished testing, but that was before I saw the posts from AB33. If you had some original code you have have posted a copy as opposed to me writing he whole thing from scratch.

For this time I am willing to accept that it was not intentional.

Please check the attached workbook. Worksheet summary_original was your version and worksheet summary was generated by the code