Need strategy to transfer data from PivotTable to report

[ease20022002]

Hi,

I have an application with a bunch of Pivot Tables that calculate Loss Development Triangles for insurance Actuaries and I have inherited this process. The way this works is the PivotTables do all the summarization of the data, but there are several separate reports that are generated from the PivotTables. The reports are hard coded in the sense that they refer directly to cells populated by the pivot table. Is there a better way to generate reports from summarization pivot tables?

This pivot table is linked to an Access db that has boku data and calculates several valuable "sections", so this isn't just a simple date by revenue, or something like that. To give you some perspective, it probably took about a day or two for someone to manually reference all the cells that need to be added into one cell, and the report is literally 1200 rows by column AX.

My goal is to generate a dynamic report that can change with a changing Pivottable...

Can anyone point me in the right direction?

Thanks for any ideas...

 

[Norie]

Have you looked at the GETPIVOTDATA worksheet function?

 

[ease20022002]

Yes, and I was hoping there would be something even better, but I am now assuming there isn't...If anyone else out there has any ideas, I'm all eyes...

Thanks...

 

[Norie]

What's the problem with GETPIVOTDATA?

 

[ease20022002]

never said there was any problem...sometimes there are even better things out there, but I was think of getpivot from the beginning, but I may have to duplicate the work the other guy did that took a day...

Thanks...