Print single sheet with different footers such as file copy, trucker copy, office copy...

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3169220%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EPrint%20single%20sheet%20with%20different%20footers%20such%20as%20file%20copy%2C%20trucker%20copy%2C%20office%20copy...%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3169220%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20would%20like%20to%20print%20three%20copies%20of%20a%26nbsp%3B%20single%20sheet%2C%20one%20for%20file%2C%20trucker%2C%20and%20say%20office.%20Does%20it%20require%20creating%20copying%20the%20single%20sheet%20and%20then%20using%20the%20footer%3F%20Any%20help%20would%20be%20appreciated...Thanks%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3169220%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EOffice%20365%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Visitor

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

 

1 Reply

@Pilgrimric 

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.

 

NikolinoDE

I know I don't know anything (Socrates)