Forum Discussion
Compare two large excel sheets
Hi All,
I have two large excel sheets of projects information of almost identical data but sheet2 contains some incremental changes i.e. some new projects as well as some changes in the existing projects.
Whats the best way to compare two sheets and get only items which are added/updated in the second sheet.
1 Reply
The best way to my knowledge is to use a tool called spreadsheet compare (I believe it comes with Office Professional Plus):
However, if you don't have that option I would suggest you go about it using one of the approaches addressed (One is VBA Driven and the other is Formula Driven) in this thread:
https://techcommunity.microsoft.com/t5/Excel/compare-two-worksheets-if-identical/td-p/195391
