Excel headers and footers

[JimmyWilliams]

Hi guys,

I have a excel document of 12 pages.
My current layout is 3 pages side by side, and each of those has data that goes over a few pages. (I think I will need vba?)


A, B and C are all different types of reports all within a single Sheet.
A = Daily Construction Report
B = Invoice Reports
C = HSEC Summary Report

the excel document's *Page Layout View* looks like this.
[A, B, C]
[A, B, C]
[A, , C]
[A, , C]
(the Invoice reports have less rows of data then the other two Reports).

I want to make it so that all the Daily Construction Report will have the same headers and footer.
All the Invoice reports will have the same headers and footers.
All the HSEC Summary Reports will all have the same headers and footers.

(ideally I would like them also to be numbered. Daily Construction Report from page 1 to 4. Invoice reports from page 1 to 2, HSEC Summary Report from page 1 to 4)


Any ideas?

[Trevor_S]

Set up a named range for each report - say ReportA, ReportB and ReportC. Then use this macro:

Please Login or Register  to view this content.

The key thing is that you are actually sending three individual prints, and the macro allows you to change the page setup between each.
See this article for details of the other PageSetup properties that you could use: https://msdn.microsoft.com/VBA/Excel...p-object-excel

[JimmyWilliams]

Set up a named range for each report - say ReportA, ReportB and ReportC. Then use this macro:

Please Login or Register  to view this content.

The key thing is that you are actually sending three individual prints, and the macro allows you to change the page setup between each.
See this article for details of the other PageSetup properties that you could use: https://msdn.microsoft.com/VBA/Excel...p-object-excel

Thanks for the reply.

what you linked to, looks like what I have been finding on google for myself.
My understanding is that: I am asking for the impossible. The only 'solution' to my problem rename pages before you print them.


Am I correct in guessing that its not possible to have an interactive excel sheet with the correct header until producing the actual report?


thanks

Jimmy.

[Trevor_S]

If you use headers and footers in excel, you only see them when the report is produced (either by printing/print previewing or generating a PDF). Its not like Word, where when working in page layout view, you work with pages displayed aa they will print.

If you need them visible at all times, then the alternative is to not use the header/footer functionality, but instead have the report titles typed into cells. You wouldn't have to retype every time - for example if each page was 50 rows long, cell A51 could contain =A1 (to pick up the title) and cell A100 could contain =A50+1 (to add 1 to the page number).

[JimmyWilliams]

If you use headers and footers in excel, you only see them when the report is produced (either by printing/print previewing or generating a PDF). Its not like Word, where when working in page layout view, you work with pages displayed aa they will print.

Typically I word in excel on the on "normal" view (bottom right hand side to select views)
However for this particular document it makes a lot more sense to view and work in it as "Page Layout" view (also bottom right hand side to select views).

If you need them visible at all times, then the alternative is to not use the header/footer functionality, but instead have the report titles typed into cells. You wouldn't have to retype every time - for example if each page was 50 rows long, cell A51 could contain =A1 (to pick up the title) and cell A100 could contain =A50+1 (to add 1 to the page number).

I think I understand.. however that means there will be headers in the middle of data on the excel sheet?
Consider A, B and C to be long lists (rows) of data.
I think this way would be problematic.


Regarding the:

Please Login or Register  to view this content.

I will have to try this.
Thanks

Jimmy