Copying/Pasting Data from All Files in Folder to Master Sheet According to Headers

[sdwhiteh]

Hello all,

I'm new to coding vba. The goal of my macro would be to loop through all files in a folder running a macro that rearranges the files' format and copies the desired range. Then copy this range of data to a master sheet matching the data range to the correct header which is a date.

So far I have code on the personal workbook that formats the individual files and copies the data range I want. I know there is code that can loop this macro through a folder running it on each file; I just have not integrated this code with mine yet. But, I do not know how I will be to match the copied data from the individual files to the column headers they need to be pasted under. It'd be much appreciated if anyone could help with this.

The macro on the personal workbook reformats this original txt file.

Original txt-min.png

The macro turns the original text file into the format below.

after mac.png

So the overall vba code should be activated by the Weld Scrap Dollars button, call my macro (which is called WeldScrap()), and paste scrap dollar values to master sheet according to code and date.

transfer2.png

If anyone could help with this I'd really appreciate it!

The vba code on the personal workbook I put in a word file attached to look at sorry for the inconvenience.
Several input files and a skeleton of the master sheet are attached. I would attach the full master sheet if it wasn't due to file size constraints.

[sdwhiteh]

Please Login or Register  to view this content.

[Marc L]

Hi !

[…] a macro that rearranges the files' format and copies the desired range.
Then copy this range of data to a master sheet

Seems you forgot to explain what is desired range ! And where is master sheet ?! Attach the workbook …

[sdwhiteh]

The desired range of data to copy would be the cells in the green box under "Scrap Dollars" in the second picture. So it would be E2:E17. And, sorry it forced me to wait an hour before I could upload any more attachments, but here is the master sheet attached.Scrap Master Sheet Rev3.xlsx

[Marc L]

Not all very obvious but for now I can't read your attached text files with my usual code :
got an error #62 Input past end of file …

If there are not your true files, attach a couple of real ones. Otherwise, I go my way …

[Marc L]

Duplicate …