M
Max2073
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.
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.