I have multiple files with multiple worksheets, is there any way to get a
consectutive page numbers throughout all of the workbooks?

Yes. Select all the workbooks and print them together. If you have entered a
page number in every workbook, the numbers will be consecutive. Check first
in Print Preview.

"G.W" wrote in message
...
I have multiple files with multiple worksheets, is there any way to get a
consectutive page numbers throughout all of the workbooks?

I attempted that course of action, but each file is printing out as 1 of 7, 1
of 3, etc. Is there any way to link the files to have a number sequence, as
the example above, 1-10?

G.W

You can get the page numbers to be sequential in a single workbook by
Grouping the worksheets and then printing. You could try opening all your
workbooks, grouping each one and then print them all at once. Be sure to
"ungroup" before making any changes.
I have no idea whether or not this will work but I thought it might be worth
a try.

Mike Rogers

"G.W" wrote:

I attempted that course of action, but each file is printing out as 1 of 7, 1
of 3, etc. Is there any way to link the files to have a number sequence, as
the example above, 1-10?