I have multiple .txt files (usually between 3 and 17 per day) that have specific data needed to fill an excel table. These files are currently copied to a common folder, and is "formatted" as shown in the second tab of the excel file. An example .txt file and the table (with example data) is attached. Ideally, I'd like a VBA macro to do this.
This topic was initially discussed at the bottom of http:/Q_28260763.html
, where code was suggested and I was advised to open a new question to handle the specific data. <<this paragraph added on 9 March 2015 by byundt>>