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.

Supposing you have a loop through the cells of column A, How can you
distinguish between Data and the other cells you want to delete?

What code do you have at the moment?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"mary" wrote:

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.