View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default Coillating tracking number list !

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)