Rows to print on everypage

[rhanrhan]

Hi I'm currently working on a document and have run into a problem. So I want certian rows to appear on each page like a header but not a header. I know that the way you do this is go to:
page set up -> Sheet -> Print Titles -> Rows on top -> and then you select the rows you want to appear
So I did that with eg.
Department: Wyomming
Managar: Yeti

BUT I want anthoer row to only appear on pages 1-3 and then another on pages 4-5 etc
eg Page 1-3 looks like
Department: Wyomming
Managar: Yeti
Employee: Sass

and Page 4-5
Department: Wyomming
Managar: Yeti
Employee: Merival

Does anyone have any idea how to do that?

 

[Jeff Meyers]

Here's a simple approach.

Set-up your worksheet as in the example below
Then use the recorder to create your print Macro
Note: I would set all other print options in advance: orientation, margins, titles (i.e. Rows 1 & 2), etc.

In your Macro (via the recorder):

• Hide Rows 4,5, & 6
• Set the print range for Pages 1-3
• Print
• Display Hidden Rows 4,5 & 6
• Hide Rows 3,5, & 6
• Set the print range for Pages 4-5
• Print

Repeat this pattern for all employees and their associated print ranges / pages

At the end you can choose to display (unhide) all rows with employee names or keep them hidden

Remember to click on Stop Recording
And now you have a Macro to print your report in your desired format.

Here's the example:

Sheet1[TABLE="class: html-maker-worksheet"]
<thead>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[/TR]
</thead><tbody>[TR]
[TH]1[/TH]
[TD]Department: Wyomming[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD]Managar: Yeti[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]3[/TH]
[TD]Employee: Sass[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]4[/TH]
[TD]Employee: Merival[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]5[/TH]
[TD]Employee: Percival[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]6[/TH]
[TD]Employee: Arthur[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]7[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]8[/TH]
[TD]Blah Blah Blah[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TH]9[/TH]
[TD]Lorem Ipsum[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TH]10[/TH]
[TD]Blah Blah Blah[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TH]11[/TH]
[TD]Lorem Ipsum[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TH]12[/TH]
[TD]Blah Blah Blah[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TH]13[/TH]
[TD]Lorem Ipsum[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TH]14[/TH]
[TD]Blah Blah Blah[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TH]15[/TH]
[TD]Lorem Ipsum[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TH]16[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]17[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TH]18[/TH]
[TD]------------------------[/TD]
[TD]----------[/TD]
[TD]----------[/TD]
[TD]----------[/TD]
[TD]----------[/TD]
[TD]----------[/TD]
[/TR]
[TR]
[TH]19[/TH]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Excel 2010