Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print tab for each page field in PivotTable
Any ideas?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Pivottable - show all selected items in page filter | Excel Discussion (Misc queries) | |||
How to print multiple columns on same page | Excel Discussion (Misc queries) | |||
How to print 2 Excel pages side by side on 1 printed page? | Excel Discussion (Misc queries) | |||
tOTALS WON'T PRINT ON SAME PAGE | New Users to Excel | |||
How do I refresh a PivotTable and remove outdated page field entr. | Excel Discussion (Misc queries) |