Delete repetitive headers from imported text report

[ianmaggy]

Hi,

I'm working with an imported .txt report in Excel. On every page from that report, there is "header" information that I want to remove (delete and move up the rows) from the data. The first line of the header always start with the same text; so it is easy to find.

What I'm trying to have excel do is starting from line 4 find the specific text ("LONGUEUIL") and delete (and move up) the row where this string is found along with the next for 4 rows (that's my hurdle) and loop until all the "headers" are gone!

Thanks in advance

[scott.s.fower]

easy to do, can you post a sample so we can write the code?

[scott.s.fower]

this should work for you, change the column that "LONGUEUIL" is in from A to what ever also check that I spelled LONGUEUIL is spelled correctly

avec plaisir

-scott

Please Login or Register  to view this content.

[ianmaggy]

Even without a sample you got it!

New to this VBA thing...

Merci beaucoup (thanks a lot, in case you did not get it )

[scott.s.fower]

Bien sur, si vous plait marqe le thread solved:D