Saturday, May 23, 2015

Easily Combine Multiple Excel Workbooks With RDBMerge

Now, you can combine multiple excel workbooks, xml and csv into one summary workbook with an excel add-in so called RDBMerge.

At first, just download and extract the correct version to a local directory. Copy and paste the RDBMerge on your system to a unprotected directory. Begin your new session on Excel and open a new workbook.

Dipopedia-RDBMergeAddInExcelPenggabungData.png

Additional tips:

  • On Excel 97-2003: Click Tools, click Add-Ins, go to the add-in by using Browse and then click OK. Verify the RDBMerge is checked in the add-in list and then click OK.
  • On Excel 2007: Click the Microsoft Office Button, click Excel Options and then click the Add-Ins tab.
  • On Excel 2010-2013: Click on File, click on Options, click the Add-ins tab. Choose Excel Add-ins in the Manage drop-down then click Go. Go to the add-in by using Browse and then click OK. Verify the RDBMerge is checked in the add-in list and then click OK.

Using the RDBMerge Add-in

In Excel 2007-2013 you will find a button named RDBMerge on the Ribbon on the Data tab to initiate the UserForm. In Excel 97-2003 you will find the menu option RDBMerge in the Data menu to initiate the UserForm.

Folder Location: In the folder location area click on the Browse button and select the folder with the files you want to combine. After you do finish, you see the path returned in the UserForm. For more information, you can click on the Tips button.
Which Files: In the area of Which Files, you can select the type of files in the dropdown that you want to combine. If you use the first option XL? it will combine all type of Excel files with an extension that begin with XL (xls, xlsx, xlsm, xlsb). For more information, you can click on the Tips button.
Which worksheet(s): In this area you will have the option to pick up the worksheet by index or name. For more information, you can click on the Tips button.
Which range: You will have the option to combine a fixed range which is can be more than one area. For more information, you can click on the Tips button.

When you click on the Merge button it will then create two worksheets in a new workbook, namely:
  1. Combine Sheet with all the data in it.
  2. Log Sheet with copy/paste and error information in it.

There you have about how to easily combine multiple excel workbooks with rdbmerge.
No comments: