export specific cells to several text files

[BSJ]

Hi,

I know my way in Excel but I am a complete newby in VBA! I am looking for a solution to export a number of cells to a specific text file. Attached a short version of the data, the total file contains about 19.000 data fields.

I want to export the [data] to the specified folders and files. i.e. folder 1 - file A would contain the following data:

[data] :: this field is required in each file
1=230
2=230
10=230
<empty line required>

Each time the cell starts with 1, the file changes, the folder changes whenever there are 12 files completed, so files A thru L.
If the file exists, it should be overwritten or the data should be replaced with the new data.

I hope you guys can help me to solve this, because that would save me a lot of time...

Thanks!

[JBeaucaire]

Post the resulting txt files expected from that dataset so we can truly see the results.

[BSJ]

Text file A.txt should be written to folder 1, text file B.txt to folder 2.