Pivot Table - copy specified Grand Totals

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top