HOW TO MAKE AUTOMATICALLY UPDATING THE NEXT PAGE NUMBERS
 

....

HOW TO MAKE AUTOMATICALLY UPDATING THE NEXT PAGE NUMBERS
 

FilePrint PreviewSetupHeader/Footer
OR
In sheet1 A1 Type Page1
in sheet2 A1 =("Page"&(RIGHT(Sheet1!A1,1)+1))
in sheet3 A1 =("Page"&(RIGHT(Sheet2!A1,1)+1))


"please send me the answer" wrote:

...

HOW TO MAKE AUTOMATICALLY UPDATING THE NEXT PAGE NUMBERS
 

Forgot to mention:
The last formula conks out after the 10th page...
Page 100 =("Page"&(RIGHT(A1,3)+1))
If you have more pages you have to leave 2-3 space after 'Page', then
increase the space amout counted from the right in the formula (A1,3) for 3
digit numbers etc...


"ufo_pilot" wrote:

FilePrint PreviewSetupHeader/Footer
OR
In sheet1 A1 Type Page1
in sheet2 A1 =("Page"&(RIGHT(Sheet1!A1,1)+1))
in sheet3 A1 =("Page"&(RIGHT(Sheet2!A1,1)+1))


"please send me the answer" wrote:

...