I have a workbook that I am trying to print. I have 5 sheets in this workbook each with multiple pages. When I go to print the entire work book, the header creates the following page numbers:
page 1 of 20
page 2 of 20
page 3 of 20
...
What I want is for it to start over with every new sheet like this:
page 1 of 3
page 2 of 3
page 3 of 3
page 1 of 5
page 2 of 5
...
page 5 of 5
page 1 of 2
page 2 of 2
Is this possible? Any suggestions would be greatly appreciated.
page 1 of 20
page 2 of 20
page 3 of 20
...
What I want is for it to start over with every new sheet like this:
page 1 of 3
page 2 of 3
page 3 of 3
page 1 of 5
page 2 of 5
...
page 5 of 5
page 1 of 2
page 2 of 2
Is this possible? Any suggestions would be greatly appreciated.