I want to print 2nd, 3rd and 4th sheet of an excel worksheet in pdf format.
The sheet numbers given above are the Index Number of sheets.
The printed pdfs should get saved separately for each sheet in the same folder as the excel sheet.
Names of the pdf should be as follows:
1st sheet pdf = "Total Summary"
2nd sheet pdf = "value in C6 of sheet 2" & "Summary"
3rd sheet pdf = "value in C6 of sheet 3" & "Summary"
Example: if cell C6 of 2nd sheet contains name "John", then its pdf copy should be saved as "John Summary".
The question has been cross-posted here MrExcel
The sheet numbers given above are the Index Number of sheets.
The printed pdfs should get saved separately for each sheet in the same folder as the excel sheet.
Names of the pdf should be as follows:
1st sheet pdf = "Total Summary"
2nd sheet pdf = "value in C6 of sheet 2" & "Summary"
3rd sheet pdf = "value in C6 of sheet 3" & "Summary"
Example: if cell C6 of 2nd sheet contains name "John", then its pdf copy should be saved as "John Summary".
The question has been cross-posted here MrExcel