Printing multiple, and different, sets of header rows

[arbeeone]

I'm wanting to repeat 4-5 header rows on each page (NOT Header/Footer) but also to change the Rows that are printed at different, known stages through the report when I force a Page Break.

By using the .PrintTitleRows feature, I can print one set of header rows, but I can't see how to change it - potentially several times - through the report.

Any help would be appreciated!

rsb

 

[fumei]

I'm wanting to repeat 4-5 header rows on each page (NOT Header/Footer) but also to change the Rows that are printed at different, known stages through the report when I force a Page Break.

Please restate EXACTLY what you are doing, and want to do.

From reading your post it sounds like you have one big table...and only one table. If this is correct...well a table only has ONE header row. If there multiple header rows required, you will need multiple tables.

Describe the document. Also, I am not totally sure which app you are wanting help on.



Gerry

 

[arbeeone]

There is a single large input file coming into Excel which is being reformatted using VBA into 3 types of reports: a) detail b) first level summary (based on certain fields) and c) overall totals, plus some quite 'fancy' formatting that is required (colours etc). Each of the 3 types of report has need for a different header (which are 3-5 rows) in size.

As you stated, I am only able to get 1 header and was wondering how I might either get multiple headers, OR some technque to get around this.

rsb

 

[PHV]

Why not have 3 sheets, one for each report ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fumei]

Chuckle....that would work.

Gerry

 

[arbeeone]

I was trying to avoid going to multiple sheets if possible because the reports would themselves then have to be sorted, or it would require a potentially large number of print commands.

Although there are three report 'types' as shown above, there are potentially many more than just 3 reports. The overall report occurs once, but then there is a 1st level summary followed by a detail report and this 'pairing' can be repeated 'n' times.

If I were to use 3 sheets, sheet 1 would be the overall, sheet 2 would be all the 1st level summaries and sheet 3 all the detail reports - but this would involve sorting the reports themselves into sequence. I can get around this by having 'n' sheets - following the sequence Overall, Summary 1, Detail 1, Summary 2, Detail 2, Summary 3, Detail 3, etc. This would certainly work - and is easy for me, but it then requires the users (of whom there are a lot) printing multiple sheets rather than just 1.

This is why I was trying to see if there is some system feature within Excel which would allow me to keep it all on the one report.

rsb