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)