| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I separate text without a space? | Excel Discussion (Misc queries) | |||
| Print Area ranges print on separate pages? | Excel Discussion (Misc queries) | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
| How do I import a list of names into a separate form that prints . | Excel Worksheet Functions | |||
| Non-Breaking Space + Print Issue | Charts and Charting in Excel | |||
Linear Mode
