I have an excel doc with 7 columns of data pulling from another sheet, each column in 45 rows deep and after the 45 rows as 2 rows of formatting i need to enter. I need a seperate TXT file for each column (or set of 45 rows).

soo it looks something like this

A b c d
1 1 1 (blank)
2 2 2
3 3 3
4 4 4
.. ... 33
45 45 end
end end file
end file

I need a macro that will look in each of the rows and first see if there is data, so it will only export if there is data to export. then it needs to know where the data ends and in which column as each column needs to export to its own TXT file.

Finally, I need it to say end and end file in the last two rows 46 and 47 in the txt file for each file.

Im guessing i need a loop of somesorts but i have no idea how to build it.

Any help would be great