View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 419
Default Coillating tracking number list !

James,

Please clarify: Your data is in XL in a list format (rows & columns)? You
are importing from XL to Publisher? Are you importing into a form of some
sort in Publisher (not familiar with publisher at all) that is setting up
these receipts in the print layout (4 to a page)?

Let me ask, after you import from XL to Pub, is the data that has been
transfered going to be deleted in XL or are you going to add new data to it?
If you are adding new data, are the receipts that have already been printed
going to be printed the next time around or are they getting marked so they
will not be printed the next time around (only new records get printed)?

If you can, please provide sample data with column/row lables and column
letters/row numbers.

Conan




"james" wrote in message
...
OK first like say this question is TUFF..i posted this in Ms Publisher
General AND Printing..NOone can figure it out (I used publisher to
import excel list into)

I am making receipts 4 to 1 page, and made tracking or order numbers for
each receipt, so on first 8.5x11 page be 1 receipt with say 001,then
another
with 002 and another 003 and final 004... then 005,006,007,008 be on the
next
page below
I accomplished this task just fine,however i realize when i cut the pages
into 4 stacks,the 4 piles are not in order...001 is on top 1 stack but 002
is
on the other, therefore i have to manualy sort them by hand later.
SO what i need is a methd template or formula to have te numbers run in
order DOWN the page not across.

(i ve searched all over for thisand i must say its stumping everyone)