Thread: HOW TO MAKE AUTOMATICALLY UPDATING THE NEXT PAGE NUMBERS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ufo_pilot
 
Posts: n/a
Default 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:

...
Reply With QuoteReply With Quote