Compare data in two excel sheets

Hello,

I have huge data in two different excel sheets (same work book), approx. 10 columns & 5000 rows. I want to compare both the sheets and find the difference.

Ideally both the sheets must have same data, as they are extracted running same queries from two servers (old & New (post data migration))

Now the data in the new sheet might have some additional data which is not present in the old sheet and also some data might be missing in the new sheet as compare to the old sheet.

Kindly help me on this. Aniticipating an early response.

Thanks,
Anil