Print tab for each page field in PivotTable


S

Scott Hernandez

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!
 
Ad

Advertisements


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