LearnVBA83
Board Regular
- Joined
- Dec 1, 2016
- Messages
- 112
- Office Version
- 365
- Platform
- Windows
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!
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!