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