Tech Stumps

  • Home
  • Android
  • iOS
  • Smartphones
  • Tablets
  • Tricks

How to Merge All Excel Worksheets with RDBMerge Add-in

in: Excel MS-Office Softwares Tricks
Do you have so many of MS-Excel worksheets containing same format? If you want to merge all worksheets that containing same format data, you will do it by copy data in various sheets and then paste it on a single workbook. It’s very common and manual method when your number of files is low. Otherwise there are so many Excel files you have, what to do? So you will spend more time on it and you will take care of merging correct data.

However you will face some problems while merging excel sheets manually, I found an excellent Add-in for merging data of many worksheets to a single Excel worksheet. That is RDB Merge Add in for MS-Excel, Which makes the work simpler and faster. You can merge the Excel files within a folder that are containing same format.

Click below the link and download the RDB-Merge Add-on for your MS-Office version 2003 /2007. Download RDBMerge Add-in for MS-Excel 

To add this downloaded Add-in to Excel window, Click on Excel Options ->Add-Ins-> Go -> Browse and Select the RDB-Merge. You will see the RDBMerge on Data Menu/Panel. Alternatively you can double click the downloaded RDB-Merge Add-in Excel file that will be opened directly.

How to Combine All Excel Worksheets Data


1. First you have to open the first Excel workbook that to be merged

2. Click the RDB Merge Addin icon and select the folder that contains the all Excel files to be merged.
3. Choose the MS-Excel version (XLS,XLSX)

4. You can Merge worksheets by All, Sheet Name, Sheet Index

5. Select the data range with same format like (A1:C3) or you can denote the column range A to G (A:G)

6. If your data contains formula values, please make a tick on “Paste as Values”

7. Click on Merge Button and you have done. The merged/combined Excel Workbook will be opened to your desktop.

 Download RDBMerge Add-in for MS-Excel

6 comments:

  1. MathivananSeptember 29, 2012 at 11:18 AM

    Very useful information to me. Thanks

    ReplyDelete
    Replies
      Reply
  2. perumal karurOctober 3, 2012 at 1:05 PM

    GOOD INFO THANKS....

    ReplyDelete
    Replies
      Reply
  3. Kannan DevadassOctober 5, 2012 at 9:09 PM

    Very useful information. Thanks4sharing..

    ReplyDelete
    Replies
      Reply
  4. Kannan DevadassOctober 5, 2012 at 9:11 PM

    Useful information. Thanks4sharing

    ReplyDelete
    Replies
      Reply
  5. Iniyavaniniyavan IniyavanNovember 6, 2012 at 9:51 AM

    Thanks for the information

    ReplyDelete
    Replies
      Reply
  6. victordiasMarch 22, 2016 at 7:29 PM

    Good for me. Is there any new version of this program?

    ReplyDelete
    Replies
      Reply
Add comment
Load more...

Newer Post Older Post Home
Get Updates in Email. Join with 500+ Readers
  • RSS Feed
  • Twitter
  • Google Plus

Popular Posts

  • How to Check your Pen Drives Original or Fake?
  • NHM Writer – {Best} Free Tamil Typing Software for PC
  • Thor: The Dark World Official Game Now Free for Android and iOS
  • How to Merge All Excel Worksheets with RDBMerge Add-in
  • Download Temple Run 2 Game for Android and iOS devices
  • UIDAI Launched Official Aadhaar app for Android
  • 3 Ways to Access Mobile WAP sites on your PC / Computer
  • Contact Us
  • Privacy Policy
  • Sitemap

"© Copyright 2011-16" TechStumps.com · All Rights Reserved ·