Two formulas referencing two date ranges on one pivot table.... Possible?

[heather1209]

Hi all!

So I'm not sure if this is even possible, but I have a workbook that needs to reference one pivot table that encompasses several weeks worth of data. In the workbook, I have two sets of data, each referencing two different weeks. Both weeks worth of data are available in the pivot table, but of course to physically see the data, you would need to manually select the desired dates in the pivot table. Is there any way to make a formula or a macro to get the data for one week and then get the data for the other week and put it into the workbook?

Visual, if it helps:

Week 1:
Data from week 1 for person 1 from pivot table
Data from week 1 for person 2 from pivot table
Data from week 1 for person 3 from pivot table
Data from week 1 for person 4 from pivot table

Week 2:
Data from week 2 for person 1 from pivot table
Data from week 2 for person 2 from pivot table
Data from week 2 for person 3 from pivot table
Data from week 2 for person 4 from pivot table

So far, I got the following to at least fill in the data based on whatever date range is currently selected, but of course it's not relevant for both weeks, or either week if the wrong date range is chosen:

Please Login or Register  to view this content.

[dilipandey]

Hi heather1209,

I guess you can use GetPivotData function here... but not sure unless I see the sample workbook, please upload. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>