Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Columns or labels in Word
I will do my best to spell out the issue I'm having. I have an excel sheet
with 5 columns of data. I am creating "tickets" about 1" x 2.5" with this data. Each ticket uses one record of data from the excel sheet. I want the ticket formatted in such a way where the first 3 columns of data stack on top of the last two. I am able to use the "label" utility to do this. My first question is. Does anyone know any tricks to do this so that I don't have to use labels? I tried in excel to use cell references, but when I fill down, I can't get Excel to logically "understand" what I'm trying to do. (i.e. =A2 then =B2 then =C2, then one row under that I tried =D2 then =E2) My other question is regardless of whether I use labels or columns, can word work all the way down to the last sheet needed and then across? Labels want to work right, and continue to fill. Columns work to the bottom of one sheet (snaking columns) and to the nest column, etc until it's done with the one sheet. Because of how I have to "divvy" out these tickets, my procedure would be much easier if I Word calculated the number of pages necessary and filled one entire column (i.e. from sheets 1-5) and then returned all the way to the top and filled down etc. Any help would be greatly appreciated. Thanks, Aaron |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns or labels in Word | Microsoft Word Help | |||
Labels in Word are repeating 2 columns | Mailmerge | |||
Combine columns fr: Excel - Link to labels in Word | Mailmerge | |||
sheet of mailing labels with three columns, 10 labels per page | Mailmerge | |||
Merge in Word adds labels between columns | Mailmerge |