![]() |
How do I print two separate cells in a certain space on a form
We have a gift card that has a space for the sender's name/comment and order
number. These items will be downloaded into an excel spreadsheet daily from a website. The name/comment is in one cell, the ordernumber in another cell. We need a way to print this information on each gift card. Is there a way to create a template, a program, or something that takes the name/comment and ordernumber to print on the gift card? ... with minimal set up each time. Thank you reioptions |
How do I print two separate cells in a certain space on a form
Assuming Name comes in to cell A1 and order number is in B1, in some other
cell put: =A1 & " " & B1 use that cell as the source of information on the card. Since I don't know how you're getting the information from Excel to your cards now, I can't offer much more than that at this point in time. "reioptions" wrote: We have a gift card that has a space for the sender's name/comment and order number. These items will be downloaded into an excel spreadsheet daily from a website. The name/comment is in one cell, the ordernumber in another cell. We need a way to print this information on each gift card. Is there a way to create a template, a program, or something that takes the name/comment and ordernumber to print on the gift card? ... with minimal set up each time. Thank you reioptions |
How do I print two separate cells in a certain space on a form
The simplest way will be :
highlight/select whatever you want to print by dragging or holding the mouse fileprint on the printer square menu check "selection" and print. It will only print the previously selected(or highlighted) items. Enjoy it. "reioptions" wrote: We have a gift card that has a space for the sender's name/comment and order number. These items will be downloaded into an excel spreadsheet daily from a website. The name/comment is in one cell, the ordernumber in another cell. We need a way to print this information on each gift card. Is there a way to create a template, a program, or something that takes the name/comment and ordernumber to print on the gift card? ... with minimal set up each time. Thank you reioptions |
All times are GMT +1. The time now is 01:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com