Combine Multiple Daily files in VBA

[LearnVBA83]

Hi Excel experts.

I get these daily report that are in the same format and was wondering if it's possible to be able to drop all the files for a month into one folder and have a macro combine them into one excel file? The headings are in A2 to K2 and I would only want the heading to appear one time. All of the files should have one tab. Is this possbile?

Thanks!

 

[alansidman]

 

[LearnVBA83]

Thank you! Great video! Any idea if there is a way to do this when i want to change out all the files weekly... without having to go back through the build process? When I build it based on the video it worked but errored out when i replaced all the files with the next week. Also, these reports are exactly the same except half of them have one extra column that the others do not have and I'd like that added as well for those... Is that possible?

 

[alansidman]

Just change the name of the source in your Mcode.