Template or Excel ?

[drctest]

Hi All,
I need to create three copies of a receipt, and obviously would like to
enter the data only once and have the other two receipts print automatically
on the same page, including the prompt information. The receipt only needs
to be approx 1/3 page so there is room for two more copies. I've tried
working with a 3-up template but that template is to have three separate
receipts - not duplicates.

I'm wondering if there is a way I can create a simple excel spreadsheet
where I put the required info and then have it formatted out as a simple
receipt.

A brief example of info required: LName, FName, ID#, Class, Date of Quiz,
Time of Quiz, Where student is seated, initials of person who proctored,
where to deliver completed Quiz, etc. I have a pub version of the receipt we
PRINT using NCR paper, and would LOVE to be able to make that form work, but
I am seriously stumped.

Can anyone steer me in the right direction? THANK YOU!

drctest

 

[Luke M]

You can modify the 3-up template. On the other two "receipts", edit the cells
to have formulas leading back to "original" reciept.

For instance, if A2 is a space for the name on original reciept, have the
other two reciepts cells where name would normally be entered have formula:
=A2