Solution Needed For Printing Titles Issue

[STEVEMILLS04]

I have a sheet with several pivot tables, graphs, tables, headers, etc... stacked vertically. The first couple of pages of content fit on onto their own single page, however, the last Pivot Table spans 4-5 pages and to throw a wrench into things, I am using the pivot table to add long formulas to the left of it to represent the data as I need it so it is a combination of a pt and a range of cells, organized to look like one table.

What I need is the first few pages to not repeat any titles, then the final few pages that have the last pt should repeat a static set of headers.

I am open to just about any solution, including VBA, as I will be the only one working in the Excel version of the report.

I appreciate any help, ideas, criticism...

 

[Gerald Higgins]

Hi, if you're willing to use VBA, then write a macro that applies the print headers and prints part 1, then removes the print headers and prints part 2.

I'm not a VBA expert, so I can't write the code for you, but if you try recording a macro while you do this task manually, I think it may well give you usable code for something like this.