ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print tab for each page field in PivotTable (https://www.excelbanter.com/excel-discussion-misc-queries/105337-print-tab-each-page-field-pivottable.html)

Scott Hernandez

Print tab for each page field in PivotTable
 
All:

I run a monthly financial report and print a 'dashboard' tab for each
page field in my pivot table. Each report contains around 7-12
different groups that I pivot the data on. From the pivot table I go
back to the 'dashboard' tab and print the 'dashboard' tab (this tab
pulls in data from the pivot table as well as other tabs).

What I am looking to do is write a macro that will do the following
steps:
(1) Print the 'dashboard' tab for the PivotTable w/ 'all' fields
showing
(2) Change the PivotTable to the first page field, switch back to the
'dashboard' tab and print
(3) Copy a small range of numbers from the 'dashboard' tab and paste to
another tab
(4) Repeat for each page field in the PivotTable (can vary from
month-to-month)

Any help that can be offered is greatly appreciated! I've been
searching the internet and haven't come up with a clear way to do this.
I'm sure it can be done, I just need the aid of you Excel geniuses out
there!


Scott Hernandez

Print tab for each page field in PivotTable
 
Any ideas?



All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com