Hi All,
I need a marco that will copy space delimited text from several .txt files into one worksheet and export calculations from a linked worksheet into another text file. My original text file is huge so I've broken it up into several files that Excel can manage. My existing Excel spreadsheet takes the text through several complicated calculations and spits out a set of numbers. I need to be able to read in each text files separately and output the resulting calculations into one text file. The one text file would need to grow as each set of calculations is performed for each text file. I'm not that good with visual basic and could really use some help.

Thanks,
Chris