Changing number sequence on different pages

[Johnny Raisinger]

I have an excel spreadsheet that is 100 pages long. I would like for page 11
to say page 1 of 1, page 12 to say Page 1 of 2, and so on and so on. At page
41 I would like to start a new numbering sequence again so that it is Page 1
of 1 until the end which would be Page 60 of 60.
Is there a way to do this. I tried all kinds of ways and have failed except
to create multiple worksheet tabs so that those selected pages are in those
worksheets.

 

[Joseph R. Pottschmidt]

Dear Johnny:

I've looked at your problem, and the only way that I can see that you're
going to be able to do what you want is to copy each section into it's
own worksheet and set the numbering as you wish on it.

Joe P.


-----Original Message-----
From: Johnny Raisinger [mailto:Johnny
(e-mail address removed)]
Posted At: Tuesday, June 20, 2006 11:43 AM
Posted To: microsoft.public.excel.setup
Conversation: Changing number sequence on different pages
Subject: Changing number sequence on different pages

I have an excel spreadsheet that is 100 pages long. I would like for
page 11
to say page 1 of 1, page 12 to say Page 1 of 2, and so on and so on. At
page
41 I would like to start a new numbering sequence again so that it is
Page 1
of 1 until the end which would be Page 60 of 60.
Is there a way to do this. I tried all kinds of ways and have failed
except
to create multiple worksheet tabs so that those selected pages are in
those
worksheets.