Excel Spreadsheets Headers and Page Numbers

[Quincannon]

I am using the latest Microsoft Office and have a work sheet of 210 pages and need to add 5 different headers at various points throughout the document but can't work out how to do it. I need the 2nd one on page 58, the 3rd one on page 92 etc. Is it possible please?

Someone suggested I split the document into 5 different work sheets but then I would have the problem of page numbers. The 2nd work sheet would have to start at No 58 and the 3rd at No 92 etc. Is that possible too?

Either way would be fine by me.

Thanks

 

[Lufbrarunner]

It may be possible to do this with a bit of programming in VBA.

 

[Cory Cooper]

Hello,

I haven't done this myself, but I do believe there may be a way for either scenario. Maybe this explanation will help?

Multiple Headers in Same Worksheet

C