Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Template or Excel ?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Template or Excel ?
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 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "drctest" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Template (Creating a Function in the template) | Excel Worksheet Functions | |||
How can I link between a Word template and an Excel template | Excel Discussion (Misc queries) | |||
Automatically look in template folder when one opens a template | Excel Discussion (Misc queries) | |||
NCAA tournament brackets template from Template gallery. | Excel Worksheet Functions | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) |