I have an excel file with 70 sheets named 1,2,3...and so on.
I have a sheet called "Summary" Which contains a summary of all reports.
In this sheet, B3:B72 contain sheet names (1, 2,...3)
Column S3:S72 contain desired file names for respective PDF files.
I want to create separate PDF files of pages 1-3 for each sheet.
Is it possible? How? If a code is required, what would it be?
I have a sheet called "Summary" Which contains a summary of all reports.
In this sheet, B3:B72 contain sheet names (1, 2,...3)
Column S3:S72 contain desired file names for respective PDF files.
I want to create separate PDF files of pages 1-3 for each sheet.
Is it possible? How? If a code is required, what would it be?