Mar 05 2020 10:46 AM
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 have to send individual sheets of these reports to our clients and if there is way to export these as individual PDFs with one "print as PDF" function that would be ideal, using the sheet name as the filename. Perhaps this is a Macro function that will need to be written, but would love to hear your thoughts!
Mar 05 2020 02:23 PM
SolutionYes, that's with macro. Sample is here https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/excel-2016-sav... I believe you may google for more.
Mar 05 2020 02:23 PM
SolutionYes, that's with macro. Sample is here https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2016/excel-2016-sav... I believe you may google for more.