This may be a little complicated and perhaps unachievable, so let me explain further.
Is it possible to input a VBA/Macro to make this happen?
i can provide samples if required?
Thank you in advance.
- I make customer orders using an excel workbook template. This workbook contains 4 individual sheets which i need to print onto A4 paper.
- The sheets are automated from 1 master sheet within the workbook. So as i input data, all of the other sheets update.
- I want to add a 5th sheet, that also updates but that is an order acknowledgement for the customer.
- However i do not want to the 5th sheet to print onto paper, i want it to print as a pdf to my desktop or to a specific folder.
- So when i print the entire workbook, only the first 4 sheets print onto paper and the 5th sheet prints as PDF
Is it possible to input a VBA/Macro to make this happen?
i can provide samples if required?
Thank you in advance.
