I am using Excel 2000. I have perused the boards for hours trying to find a previous post addressing my problem and have thus far been unsuccessful. I'm hoping your experience will be helpful to me. I will try to be as precise as possible as to eliminate confusion.
I am trying to print a single worksheet multiple times, each time with a different sequential number, such as 1,2,3 etc. However I do not want the number to appear as a header or footer, i want it to appear on the worksheet itself. for example:
Company Title
Information, etc.
Project (read: Page) Number: ____30700_(30701,30702, etc.)____ {this is what I want changed when printing}
I want to start with a number and have each page print out as the next numerical number. I am unaware as how to do this, or even the best way to approach the subject. I am familiar with how to change a header or footer page, but how does one take a single cell, of a single worksheet, and manage to get the number to change sequentially when printing a number of copies?
Any help would be most appreciated. If I am required to further elaborate I will to my best to accomadate.
I am trying to print a single worksheet multiple times, each time with a different sequential number, such as 1,2,3 etc. However I do not want the number to appear as a header or footer, i want it to appear on the worksheet itself. for example:
Company Title
Information, etc.
Project (read: Page) Number: ____30700_(30701,30702, etc.)____ {this is what I want changed when printing}
I want to start with a number and have each page print out as the next numerical number. I am unaware as how to do this, or even the best way to approach the subject. I am familiar with how to change a header or footer page, but how does one take a single cell, of a single worksheet, and manage to get the number to change sequentially when printing a number of copies?
Any help would be most appreciated. If I am required to further elaborate I will to my best to accomadate.