Forum Discussion
mkloker
Mar 05, 2020Copper Contributor
Print 100+ Sheets Individually in Large Report
Hi all, I have a large report I generate monthly (100+ sheets) and would like to learn how to print all active sheets as individual PDFs for a large report without doing it per individual sheet. We h...
- Mar 05, 2020
Yes, that's with macro. Sample is here https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/excel-2016-save-as-pdf-workbook-separate-files/c79583d5-38c7-4131-b105-b70a9e1729e1, I believe you may google for more.
SergeiBaklan
Mar 05, 2020Diamond Contributor
Yes, that's with macro. Sample is here https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/excel-2016-save-as-pdf-workbook-separate-files/c79583d5-38c7-4131-b105-b70a9e1729e1, I believe you may google for more.