How do I print two separate cells in a certain space on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
The simplest way will be :
highlight/select whatever you want to print by dragging or holding the mouse
file>print> on the printer square menu check "selection" and print. It will
only print the previously selected(or highlighted) items. Enjoy it.
 
Back
Top