Printing Pivot Tables
Printing from pivot tables:
I have created quite a complex pivot table using various database queries, everything is great except for printing reports. IS there a way that i acan automate printing reports ie. where the pivot table changes in length the macro will set the pring area, scale to it to best fit and then print. Basically the macro needs to recognise where the bottom right hand corner if the data is and set the print area for this data. Another option that would be very useful is where the drop down menu in the top right hand corner of the pivot table is is it possibel to automate a print function where you can select to print all these reports at once instead of having to go into each one individually and then select All help will be much apreciated TP |
All times are GMT +1. The time now is 09:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com