Import multiple text files and create multiple workbokos

[mtolson10]

First timer on the forums, so bare with me please . I have several .txt files in one directory. I want to import each .txt file into an Excel template. Then save each as its own workbook. This template formats and has formulas to convert the .txt data to data I need. I also want to save the .txt file name as the workbook name and one cell location. I may be missing extra information, so please ask or message me. I can also post the template, if necessary. If there is a forum that discusses this, please direct me. Thanks!

-Matt

 

[arthur p wrobel]

You need to share the template.

 

[mtolson10]

Here is the link to my template:
https://www.box.com/s/vwatzigd117oiti2dkvv

I want to import the .txt files into the second sheet named "Raw Data_Instructions", starting in cell A1. Then in the the first sheet, "Calculated Data", the imported data is converted. If needed to make things easier, the second sheet columns can be moved to he first sheet. I just did it this way to keep the raw data on a separate sheet, but it really does not matter.