View Single Post
 
Old 11-15-2022, 08:35 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 674
p45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud ofp45cal has much to be proud of
Default

If you can get your Diff values into the WrkingSheet as I have done, then the pivot table only needs to be refreshed.
You may be able to get a formula to fetch the Diff values from the other books, or a macro or a Power Query query, it all depends on where you're getting the data from.
Note that I've changed the data on the WrkingSheet to a proper Excel table (called Table1) which means that you won't have to change the pivot table's source data reference at all when updating, you just have to make sure the extent of the table covers the data you want to pivot (see the grab handle at bottom right of cell F14).
Attached Files
File Type: xlsx msofficeforums49985Book12c.xlsx (21.2 KB, 3 views)
Reply With Quote