I have a report system that merges into Excel. If the report has multiple
pages however, each "page" is pasted into Excel instead of continuous rows of
data, e.g.:

Report Header

Data Header
Data
Data
Data
..
..
..

Run Date, Time, page 1

Report Header
Data Header
Data
Data
Data
..
..
..

Run Date, Time, page 2

I am trying to write a macro that will leave the first report header and
first data header so I can identify the report type, but that will delete the
"duplicate" information and the run date so that I don't have to do it
manually each time.