Using Excel 2000, 1 sheet

Is there a way to print page numbers in a certain cell.. I use page setup to repeat 10 rows at the top of each page. then I manually inserted page breaks. I need the page number to be in one of the repeated rows.


Example
1 Date____________ Name ____________
2 Company Name
3 Address
4 City, State, Zip Master Order Page _(NEED AUTO PAGE NUMBER HERE)______
5 Misc Data
6 etc
7 etc
8 etc

12-? Data
--PAGE BREAK --

Thanks in Advance for any help,
Keith

based on 10 rows per page, the following should get you started if
copied into the cells of the first unused COLUMN:

=IF(MOD(ROW(),10)=0,INT(ROW()/10),"")


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=537312

You may use a trick, if you have a column where there is something that
appears once per page (for example, the string "Name" in column E) you can
fake the page number using:
="Master Order Page _ " & COUNTIF($E$1:$E100,"Name")
If you are putting the formula in row 100, for example.

"Keith" wrote:

Using Excel 2000, 1 sheet

Is there a way to print page numbers in a certain cell.. I use page setup to repeat 10 rows at the top of each page. then I manually inserted page breaks. I need the page number to be in one of the repeated rows.


Example
1 Date____________ Name ____________
2 Company Name
3 Address
4 City, State, Zip Master Order Page _(NEED AUTO PAGE NUMBER HERE)______
5 Misc Data
6 etc
7 etc
8 etc

12-? Data
--PAGE BREAK --

Thanks in Advance for any help,
Keith