excel -10 sections - footer needs to say "Section # Page #

M

Maggie

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
 
B

Barb Reinhardt

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.
 
M

Maggie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
Space at end of multi page list to accommodate new entries 1
(headers & footers Issue) I have 2 even pages back to back!! 1
Determine if previous "character" is a section break 3
Footer height is different between sections 2
Indenting every other paragraph in Word at the same time? 0
Page numbering with Merged Document and IF statements 1
Need VBA Macro to Loop through pages and print counter in footer of each page 9

Top