Auto Insert Page numbers without Footer

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),"")

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