How can I copy all files in a folder into the same file?
If you’re wasting time with tedious and repetitive tasks in Excel, it might be time to review your processes or do some training.
Macros can be created to automate so much manual processing in Excel.
Here’s a simple “copy all files in a folder to a single workbook” macro. This one loops through all files in a folder and copies the first sheet of each csv file into the same workbook – oh and it renames the worksheet to match the file name too 🙂
Download the file here:
Consolidation Macro
Or have a look at the code here: