|
|
#3
01-10-2023, 11:33 PM
|
|||
|
|||
An excellent example why it is better to keep all data with similar structure in single table!
Had you did so (and added a Year column), you could add a filter for year to your pivot, and then you could select any year in your source table you want the pivot for, and you'd get it! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mail merge picking up data from wrong row | LisaG | Mail Merge | 1 | 01-25-2022 06:52 AM |
| Changing Existing Pivot Table Source from a DB to a worksheet | chrisdenslow | Excel | 3 | 07-24-2017 05:01 AM |
 How do I find Source of Pivot Table
|
bobmayo | Excel | 2 | 05-16-2013 12:42 PM |
|
VBA: Include Dynamic Sheet Name In Pivot Table Source Data
|
ibrahimaa | Excel Programming | 2 | 04-28-2012 12:27 AM |
| pivot table source data | hannu | Excel | 0 | 07-03-2010 04:54 AM |
Windows 8 
Office 2016
Threaded Mode