VBA: extract systematiically 5 rows and save them in a new excell file as .txt

[selsha]

Hi All,

My excel file looks like this:

chr	1	1	A
chr	2	2	A
chr	3	3	G
chr	4	4	A
chr	5	5	G
chr	6	6	A
chr	7	7	A
chr	8	8	G
chr	9	9	A
chr	10	10	G

<tbody>
</tbody>

I need to systematically extract 5 rows :

1- line 0->5
2-line 6-10
3-....
till the end of the file

and then save each 5 rows in a separate excel file in a .txt extension

May you help me solve this issue plz .

Tx in advance,

Best !