On a weekly basis I produce a number of pivot tables (6 pivot tables), I
have set the pivot tables up to run on macro - works fine.

I am now hoping to set up another macro to copy some of the grand totals
into another spreadsheet, however, the problem that I have is that: -

* The pivot tables are never the same size. eg. different number of both
rowes and columns.
* I am not sure if this is possible.

eg. If my pivot table has columns called "Oranges" and "Apples" then copy
the Grand Total (for these columns) to another spreadsheet.

Sorry, I have just should the GETPIVOTDATA function and have solved my problem.

"Max2073" wrote:

On a weekly basis I produce a number of pivot tables (6 pivot tables), I
have set the pivot tables up to run on macro - works fine.

I am now hoping to set up another macro to copy some of the grand totals
into another spreadsheet, however, the problem that I have is that: -

* The pivot tables are never the same size. eg. different number of both
rowes and columns.
* I am not sure if this is possible.

eg. If my pivot table has columns called "Oranges" and "Apples" then copy
the Grand Total (for these columns) to another spreadsheet.