filter formula? or macro cut/paste string

[Jootje]

Hi,

I importes data from a .txt file in excel.
I am strugling whether now I should use a filter formula or a macro to cut
and paste data in row 4-6. I want row 3-6, because row 4-6 is relevant for
row 3. Data in the rows are ditributes over cells by 'space' and ';' . So
filename is in one cell, words in the next and sentences in the next cell etc
for rows 4-6.



Row 1
[filename]=d2000-0177.txt [words]=3388 [sentences]=49 [lines]=414
Row 2
[filename]=d2000-0193.txt [words]=3101 [sentences]=87 [lines]=335
Row 3
[bestandnaam]=d2000-0230.txt [woorden]=4604 [zinnen]=111 [regels]=488
Row 4
143;6;41;Panelists
Row 5
223;9;47;Panelists
Row 6
256;9;50;Panelists

What filter formula can I use to get row 3-6?


Or?
Should I use macro to cut and paste data from rows 4-6 behind data in row 3?
I can't do this manually because this is only a fraction of the massive data
I have. So maybe somehting like: find the row where the string in cell
contains numbers, select/cut and paste it behind the data in the row just
above the first row where the first cell contains the string 'filename'.