Hi,

I'm struggling with how best to take 2 sets of similar data and develop a change log to reconcile the two. I've attached an example of a 3 column set of data:

Work Order
Code
Cost (Original = Tab1, Final = Tab2)

The first tab called "Original" was the original data file pulled on Day 1. The second tab called "Final" was the data file pulled after we reconciled work and made code/cost adjustments. I want to basically build a change log that foots the $ changes made by Work Order AND Code so that I can easily understand the changes made.

Any suggestions on how to tackle this? I tried a multi-tab pivot table, but I could only get the Row Label to show Work Order OR Code (I need both to see code changes by work order). I'd greatly appreciate any help. I thought about using SUMIFS to try to consolidate the two totals, but I need this so a Coordinator can just dump in the data and refresh. My spreadsheet is attached.

Thanks,

Rob
Pivot Table Example - Multiple Workbooks.xlsx