I've used a macro to do this in WORD, but haven't ever tried it in EXCEL.
I'm guessing it would need a macro though.

"Maggie" wrote:

I have a 10 section worksheet that I need to have a footer that says Section
# page # on each page for printing the whole worksheet.
eg Section 1 Page 10 would the page 10 of the whole worksheet:
Section 3 Page 59 would be page 59 of the whole worksheet