Still working on this 70 Project consolidation project that a number of you have been assisting with recently.
The end result of the Consolidation file is a printed report of 12 pages of A3 landscape; sounds horrendous I know but that's the way it is wanted.
The report is split into 3 sections; Equipment, Support and Consultants; each section has exactly the same rows and columns because it is the same 70 projects repeated in each section and consists of 4 pages per section. The sections are determined by Page Breaks inserted at the relevant places.
On the printed report I have the header row repeated so that all pages get the same headers.
I would like to find a way of repeating a Section Header for each of the 3 sections. At the minute I just have the relevant section header in the first row of each section but this does not get repeated; it is only on the first page of each section.
As a workaround I have put page numbers in the central footer and a section of text in the left footer with "Pages 1 to 4 - Support, Pages 5 to 8 - Equipment, Pages 9 to 12 - Consult" but this will need amending if the page numbers change.
As always, much appreciated.