Good Morning

I currently have to open several large reports in text format that run into the 100,000's of lines.

How can I use a macro to open the files, fix the spacing (there are set report headers) and fill one sheet and then move onto the next sheet and so on until all the data from the text file has been copied?

Thanks


Grayman