Seems to me your best bet would be to merge this data to Word. Once you have
a mail merged document, you could set it up to print duplex or print all
odds, flip the paper, then print all evens. Save the document after you set
up the merge (but before you merge) and you should be able to merge it with
the most recent data any time you want to print it. You'll create a Catalog
(version 2000 and down) or Directory merge (2002 and up).
http://www.officearticles.com/word/mail_merge_letters_in_microsoft_word.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com
"jezzica85" <jezzica85[ at ]discussions.microsoft.com> wrote in message
news:465F9B05-A7BA-498A-8C14-E1D32DDDF145[ at ]microsoft.com...
[Quoted Text] > Hi all, I have a very long worksheet, it equates to 468 pages printed.
> One
> row extends over two pages, and I always print the top row as a header on
> every page. The header goes from 1-15 on the first page and 16-32 on the
> second page. Let's say I wanted to print out my long worksheet so 1-15
> would
> be on one side of the sheet, and 16-32 would be on the other side. Would
> there be a way to do that without needing to print out half of the
> document,
> rearrange and flip the stack, and reprint the other half?
> Thanks!
|