ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I print two separate cells in a certain space on a form (https://www.excelbanter.com/excel-discussion-misc-queries/155848-how-do-i-print-two-separate-cells-certain-space-form.html)

reioptions

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

JLatham

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


FC

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