If I understand your request, the first point to clarify is that "each sheet"
does not have a page 2 - If there are 10 sheets & each one contains 2 pages
of data, each page is still sequentially numbered 1-20.
One option is to select the area to be printed on each sheet and go to
FilePrint AreaSet Print Area. Once you do this for each sheet, go to the
Print dialog box and select Entire Workbook.
HTH |:)
"sflower" wrote:
|