Printing Workbook Sheets as Separate Documents

  • Thread starter Thread starter MacGyver
  • Start date Start date
M

MacGyver

I've set up a workbook that has 25 sheets, 3 pages each.

Each worksheet is updated by the first sheet as to the serial numbe
and Tech. . . i.e. Sheet 1 serial number is 10000 for all 3 pages
Sheet 2 is 10001 for all 3 pages etc. The same Tech is listed on al
pages.

Problem, The reason each sheet is set up as 3 pages is that we mus
print carbonless sets (white/Pink/Canary) and have our new printe
staple them.

It only works corectly if I print each sheet as a separate document.
need to print all the sheets as sparate documents automatically. .
How to?

All help is appreciated, thank you
 
MacGyver > said:
I've set up a workbook that has 25 sheets, 3 pages each.

Each worksheet is updated by the first sheet as to the serial number
and Tech. . . i.e. Sheet 1 serial number is 10000 for all 3 pages.
Sheet 2 is 10001 for all 3 pages etc. The same Tech is listed on all
pages.

Problem, The reason each sheet is set up as 3 pages is that we must
print carbonless sets (white/Pink/Canary) and have our new printer
staple them.

It only works corectly if I print each sheet as a separate document. I
need to print all the sheets as sparate documents automatically. . .
How to?

All help is appreciated, thank you!
Click to expand...

have you tried Report Manager?
 
First time I've used the Report Manager, actually had to install it an
found there was no help for it. . .Cludged my way through and tried i
with the first 6 sheets and it did the job. . . Only limitation is th
lack of printer selection which means setting up the printer you wis
to use as the default with the settings you wish to use. . . Man
thanks
 
Back
Top