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

R

reioptions

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
 
J

JLatham

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.
 
F

FC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top