Print 100+ Sheets Individually in Large Report

%3CLINGO-SUB%20id%3D%22lingo-sub-1212005%22%20slang%3D%22en-US%22%3EPrint%20100%2B%20Sheets%20Individually%20in%20Large%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1212005%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I%20have%20a%20large%20report%20I%20generate%20monthly%20(100%2B%20sheets)%20and%20would%20like%20to%20learn%20how%20to%20print%20all%20active%20sheets%20as%20individual%20PDFs%20for%20a%20large%20report%20without%20doing%20it%20per%20individual%20sheet.%20We%20have%20to%20send%20individual%20sheets%20of%20these%20reports%20to%20our%20clients%20and%20if%20there%20is%20way%20to%20export%20these%20as%20individual%20PDFs%20with%20one%20%22print%20as%20PDF%22%20function%20that%20would%20be%20ideal%2C%20using%20the%20sheet%20name%20as%20the%20filename.%20Perhaps%20this%20is%20a%20Macro%20function%20that%20will%20need%20to%20be%20written%2C%20but%20would%20love%20to%20hear%20your%20thoughts!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1212005%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1212476%22%20slang%3D%22en-US%22%3ERe%3A%20Print%20100%2B%20Sheets%20Individually%20in%20Large%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1212476%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F562214%22%20target%3D%22_blank%22%3E%40mkloker%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20that's%20with%20macro.%20Sample%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_mac-mso_mac2016%2Fexcel-2016-save-as-pdf-workbook-separate-files%2Fc79583d5-38c7-4131-b105-b70a9e1729e1%2C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_mac-mso_mac2016%2Fexcel-2016-save-as-pdf-workbook-separate-files%2Fc79583d5-38c7-4131-b105-b70a9e1729e1%2C%3C%2FA%3E%26nbsp%3BI%20believe%20you%20may%20google%20for%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

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!

1 Reply