May 22 2018
01:23 PM
- last edited on
Jul 31 2018
08:13 AM
by
TechCommunityAP
May 22 2018
01:23 PM
- last edited on
Jul 31 2018
08:13 AM
by
TechCommunityAP
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.
May 22 2018 01:35 PM
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