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

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

Thanks Barb I will try to do a macro but have never done one before in excel.
I have alway had trouble with them in word as well.

"Barb Reinhardt" wrote:

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