Report Headings
 

I have a spreadsheet created from a download of another application. I need
to change the header as the report prints. The data looks like this:
Entity 1 Header Info
Entity 1 Data
Entity 2 Header Info
Entity 2 Data
Entity 3 Header Info
Entity 3 Data

The reports are actually 3 pages for each Entity. I have a macro that
formats and prints the reports. How can I change the Header when a new
Entity occurs (via the macro)? Thanks.