Sep 3, 2018
Combine Multiple Workbooks into a Single One
When you are working in a team, it happens a lot of times that you need to merge workbooks of different team members into a single one.
You can always use this macro to do this job in a few minutes. The macro will also delete empty sheets.
Copy the VBA Code and create a macro.
Create a ribbon to execute that macro.
Click on the ribbon and file selector dialog box will open.
You can select multiple excel files(.xls/.xlsx) to merge
Click on download the excel template with macro and ribbon.
Check the demo below:
