Help! How to import multiple .txt files into a single excel spreadsheet

Hi.

I have no programming experience. I'm an intern working in a lab analyzing bat calls. These calls are in text format and I'm trying to consolidate hundreds of these files (in a single directory) into an excel spreadsheet to preform statistical analysis on later. The problem is not only do I need the files imported, I also need to format the text in each file so that only the data in rows beneath "Duration(ms), F0min(Hz), F010th(Hz).....etc." are recorded and all the other information is simply noise and deleted. This will later be copied from the "temp" tab into the "data" tab as shown in the excel document attached.

Can somebody provide a code to do this? I would be really appreciated! I've uploaded the spreadsheet with a macro I recorded and also several .RM.txt files as samples


Thanks!

Thanks for the info!

hey so I got a macro written but for some reason it wont work. Can someone check and see if there are any syntax errors?

Thanks!

hi, blu37ay713, option to make it, run code "test"

PS. Tested on the three files provided.