'Pivot table data source automatically update
Please see the above image. I am trying to dynamically update the pivot table data source whenever a new sheet is created. Essentially I have a sheet with the pivot table and chart looking at a table in the sheet. We create a new sheet by duplicating and copying the previous sheet and delete the data in table to enter new data. The old sheet is NOT deleted and still present in the same workbook for us to go back in time to look.
What is happening is when a new sheet like this is created the Pivot table still looks at the table in the "old" sheet. How do I make this dynamically reference new sheet?
Thank you.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|