Display different header on each page (not sheet)

[darrelhawes]

Hello all,

I have a spreadsheet that is formatted to print on three pages. What I want to do is display a different header for each page.

I want to have it dynamically generated and not "hard coded" into the sheet because new columns are added all the time and it would be pain to reformat the "merged and centered" cell on each page each time. I could do it but I'd rather not.

Also, because of how this data is structured, I'd rather not separate it into separate sheets.

The best I can come up with is this:

* Insert page numbers into the middle header field.

* Write a macro that defines what prints for each page number. For example, Page 1 = Actuals; Page 2 = Estimates; Page 3 = Summary.

In others words, for page 1, the word "Actuals" would print, "Estimates" for page 2, and "Summary" on page 3.

Can anyone point me in the right direction to achieve this?

- Darrel

 

[darrelhawes]

Anybody have an ideas of what I could try? I feel like this should be relatively easy & that I'm missing something obvious...

 

[darrelhawes]

Going to try bumping this again because I still want to implement the feature I described and maybe it will help someone else out too.

Maybe I'll describe it differently.

What I'm looking for is a way to reformat the page number, so I can insert the code for the page number to print in the header...

... but instead of printing the page number, it prints some other text that I've defined elsewhere.

Make sense?