Feb 15 2022 10:02 AM
I would like to print three copies of a single sheet, one for file, trucker, and say office. Does it require creating copying the single sheet and then using the footer? Any help would be appreciated...Thanks
Feb 15 2022 11:03 AM
You cannot use different criteria in the same sheet for the same header/footer.
What you could do is create your own print dialog in which you enter the page(s) to be printed
and then use VBA to change the header and print the pages individually.
Or copy the same page in the same workbook into three different sheets
and create separate footers and headers for each sheet.
Formatting and VBA codes for headers and footers
Hope I was able to help you with this information.
I know I don't know anything (Socrates)