If I understand you corr4ctly, I should manually set the footer for each page. Is this correct? For some reason, your reply is displayed with N’s
In addition, is it possible to point the footer to a cell on the sheet?
Thanks
Hi Joe1010:
Using PageNumber in a footer isn't going to get the result you want. So if you do want to print a footer with some other information, skip the option of printing pageNumbers via the footer.
And put the formula I suggested in a cell near the bottom of a page if you want the PageNumber near the bottom of the page, or in a cell near the top of the page if you would like to see the PageNumber displayed and printed at the top of the page. N, in my formula is the corresponding sheet numbersheet number.
If your sheets are numbered consecutively as Sheet1, Sheet2, Sheet3, ... all the way to Sheet20, then instead of manually keying the value of N for the pPageNumber for each sheet, you may use the follwing formula to extract the sheet number for each sheet automatically ...
=CELL("filename",A1),FIND("Sheet",CELL("filename",A1))+5,2)
It takes longer to explain than to do it. So I suggest you try it out, make whatever changes you need to make to get the result you want to get.
I hope this helps.
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC