View Single Post
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
aaron aaron is offline
external usenet poster
 
Posts: 21
Default 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