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
Bookmarks