| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO MAKE AUTOMATICALLY UPDATING THE NEXT PAGE NUMBERS
....
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: ... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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: ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically enter page breaks? | Excel Worksheet Functions | |||
| Page numbers | Charts and Charting in Excel | |||
| Auto Insert Page numbers without Footer | Excel Discussion (Misc queries) | |||
| Why not automatically updating calculations? | Excel Discussion (Misc queries) | |||
| merging documents,exporting long landscape table to word with page breaks & numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
