Excel Tutorial Topics

Free Excel Bee Macro & Add-Ins

Merge Excel Sheets 2010 / 2007 / 2013

Do you have lots of Excel sheets to merge into one? You can download and use our merge macro or Add-In.

Combining few sheets manually is possible but combining too many sheets manually is not possible every-time. ExcelBee Excel Sheet Merge Macro saves you hours of time by just adding two or more Excel sheets into one within seconds. This is very powerful and easy to use VBA tool  that creates two button in your menu options, one for opening Excel workbooks and other to combine multiple sheets data into one sheet. VBA Merge Sheets Macro and Add-In are easy to use that merges MS Excel 2003, 2007, 2010 and 2013 files at a time.

Download Merge Sheets Macro

How to Use Excel Merge Macro?

  1. Download Excel the Macro
  2. Enable macros in the sheet and a menu option "Add-In" will be added at the end in Excel ribbon, just after View menu option
  3. Click on the “Open Files” button in "Add-In" menu to open files (Refer first snapshots below)
  4. Select Excel files at once (Use CTRL and mouse click to select multiple files)
  5. Once files opened, you can see each excel sheet from all the files in current workbook and "Merge Files" button enabled in Add-In menu
  6. Click on "Merge Files" button and all files will be combined into one sheet named "Consolidate_Data" at left most
  7. Now you can move and save this sheet to a separate Excel workbook

What Does This Macro Do?

If you are required to repeat this task very frequently then you should download the Excel Add-In. Once added to MS Excel it does not required any authentication and Add-In menu options will be available all the time.

Download Merge Sheets Add-In Macro

How to Use Excel Merge Add-In?

  1. Download Excel Add-In
  2. Add this Add-In to Excel and close it (Click here to view how to add new Add-In to Excel)
  3. Open any one file from the files (In case you want add all sheets in a workbook then just press "Merge Files")
  4. Click on the “Open Files” button in "Add-In" menu to add other workbooks (Refer first snapshots below)
  5. Select Excel workbooks at once (Use CTRL and mouse click to select multiple files)
  6. Once files opened, you can see each sheets from all the files opened in current workbook
  7. Click on "Merge Files" button and all files will be merged in a sheet named "Consolidate_Data" at left most
  8. Now you can move and save this file as a new workbook

Merge Sheets

Take Care: You would required to take some precaution while consolidating data for sanity and accuracy:

Both Add-In and Macro has been tested. Please report to us in case of any bug through our contact us page.