GetPivot Data from changing scope of Pivot Table

ryandonovan22

New Member
Joined
Sep 17, 2015
Messages
36
I am using a Pivot Table to show me 12 months rolling data, which will be updated on a monthly basis. From this Pivot Table I want to take the data and pull it into a table I am creating where I add more formulas to get useful data for chart creation.

I started this by using GETPIVOTDATA by just using =(Cell referece), based on a date range of 01/06/2020 - 31/05/2021, producing the Pivot table and then user built tables below.

1622623162115.png
1622623170866.png



When I change the Date range I end up with missing data in the table I created as well as data being in the wrong cells, picuted below

1622623228974.png
1622623239594.png



I am assuming this is because when I have done the =(Cell reference) when first crating this, that is all that it is trying to repeat. So my question is how do I get it to be fluid with the Pivot table that will be ever changing, and also ignore the year headers that will move up and down rows.
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,147,634
Messages
5,742,240
Members
423,717
Latest member
rubthenut

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top