Printing Workbook Sheets as Separate Documents

[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

 

[Rifleman]

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!

have you tried Report Manager?

 

[MacGyver]

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