How to Marge or Combine Multiple Excel Workbooks Into One

 

There are occasions when we need to consider combining multiple workbooks. You're working on a quarterly report, for example. You must consider the data from January, February, March, and April for the first quarter. If you keep data on a monthly basis, you'll need to marge those four files into a single workbook for a more accurate report. Of course, you could just open each workbook and copy the data to a new one. This could be done with four workbooks, but what about a hundred? Is it possible for you to manually combine those Excel files into one?

That's completely ridiculous. You'll almost certainly need an automated solution for this.

In this article, I'll teach you how to automatically merge numerous Excel spreadsheets into one. I'll be utilizing VBA for this, and you'll be able to combine multiple workbooks at once by simply hitting a button. You don't need to be a VBA expert to achieve this, so don't be concerned. This is something that anyone can do if they follow the steps below.

Select the Developer tab from the menu. Please watch this video if you don't have the developer tab on the ribbon.

Clicking on Visual basics would be the next step.

Then select "insert" and then "module."

Now create the code and retrieve the code by clicking on this link.

Click the run button once you've finished configuring the code. Done! All of the workbooks in the folder have been merged.

Inside the code, you must write the file location where the files to be merged are located.

You must write a backward slash after the file path ( \ )

You must save the worksheet in.xlsm format if you wish to use the code again.

You can add a button to combine excel files if you need to do so frequently. Simply follow the steps in this advanced Excel lesson and save the worksheet with the code. You can use any of the three methods to construct a button that runs a code. The following are the tutorial links:

To Run VBA, Create A Custom Button on The Quick Access Toolbar: https://youtu.be/WmNKgg060FM

How to Create a Button to Run VBA Code: https://youtu.be/PFq9zAhDxu0

How to Create Floating Buttons in Excel to Run VBA: https://youtu.be/Z6DhEF3VBos

Thanks a million for being here. Support us by becoming a Patron and leave a comment if you have any questions. Subscribe to our YouTube Channel for awesome tutorials on excel.