|
|
#8
11-15-2022, 08:35 AM
|
||||
|
||||
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). 
|
| Tags |
| copy data by month, copy data to name ranges, copy data usinf inputbox |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Table Merge _ Auto Delete Blank Lines (without Data)
|
Alex1s85 | Mail Merge | 7 | 05-04-2020 05:12 AM |
| Copy Data from different areas in a worksheet into a Table | Josh1012 | Excel Programming | 2 | 09-20-2018 01:51 AM |
| copy data table from pdf to excel | DIMI | Excel | 1 | 07-10-2018 11:40 PM |
|
Delete table if cell has data
|
So New2 This | Word VBA | 1 | 05-06-2013 09:00 PM |
|
Copy/Paste/Delete Table & Section etc.
|
flds | Word VBA | 40 | 07-16-2011 07:34 AM |
Windows 10 
Office 2019
Threaded Mode