Compare both Spreadsheets

[Kwesi Quartey]

Hi All, 

I’m ok at excel but I need some help. I have two spreads sheets (workbooks) now my issues is 

1. How do I compare both spreadsheets? So that I can work out if missed any data entries.

1. Is there any way to merge both spread sheets to avoid any duplicate to main the date intrgerty? 

Because of the amount of data am working with, I want to avoid comparing both spreadsheets manually for now because it would take up a lot of my time.

I am using windows 7 and office 2010

[#2]

well, if you had Excel 2013 or higher versions, then you could have used "Inquire" Add-in Embedded in Excel 2013 and later versions. it has an feature of comparing files. https://www.youtube.com/watch?v=ItvABPbiOXg

since you have excel 2010, you can still use Microsoft Free Add-in called Power Query, you can download it from Microsoft website .  here is a toturial that explains how you can leverage Power query to compare and merge your tables link is  http://www.myonlinetraininghub.com/excel-compare-two-lists.

if you want something extra-ordinary and really easy to use like spoon feeding then there isnt any better software than Excel Syncronizer Add-In  http://www.synkronizer.com  it offers trial version for free. another good thing about this add-in is, that it offers perpetual license and is not subscription based. i personally used it and it is awesome.