One of the office tasks is to print check payments. The checks have serial numbers that must be printed on the duplicate and triplicate copies. what is the macro so that when printing three copies of the check, the serial numbers (E2) are printed on the duplicate and triplicate copies only? The original copy is the check itself while the duplicate and triplicate copies are just plain blank bond papers for record purposes. Check sample attached.

Attached Files

check sample.xlsx (15.3 KB, 15 views)

[quote=Marcia;133733]One of the office tasks is to print check payments.

You don't need a macro, just setup 3 copies of the receipt (after doing a print preview you will see the printer margins, use these to place your extra 2 copies and were there is a duplicate serial put in it's place =E3. Then print the sheet and you should get 3 copies.

[QUOTE=trevorc;133735]Thank you Trevorc, your suggestion never entered my mind. We had been manually typing and deleting the serial numbers. The checks however are printed vertically so I spent time adjusting the margins to get the page accommodate three copies. Again, thank you.