Saturday, 30 March 2013

How to Merge All Excel Worksheets with RDBMerge Add-in

How to Merge All Excel Worksheets with RDBMerge Add-in

 

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

 

Google Play Books Now Available for Indian Users

Google Play Books now opened and available for Indian users today which allows downloading and reading books on Android devices. Google extended their Android Market to Google Play with more services such as Movies, Music, Books, Magazines and Applications. All the services are not available for globally because Google sets some limitations to all countries. For instance Google Play Books not available for India previously.

Google Play Books Now Available for Indian Users

Google has updated the Google Play Books app and fixed some bugs and opened the app available in India. Now Indian users can download and read books using their Android app. There are millions of books available on Google Play Store including new releases, best sellers and upcoming authors and also free books.
Google Play Books Now Available Download Android App
Users can easily search and filter the books by categories listed in the library. You can read books with any of your devices like phone, tablet or computer. A lot of free books found in the library that lets you enjoy the reading experience, though you can purchase any other paid books.

Download Google Play Books app for Android

Download Avast 8.0 Latest version with New Features

Download Avast 8.0 Latest version with New Features

Avast is one of the popular free antivirus company released a new version called Avast 8. There are 170 million peoples currently using this free antivirus in the world. The latest version comes with major improvements in features and interface also.


New Features in Avast 8.0

 New User Interface - The new metro style user interface gives you clear view of the program and you can easily access the features.

 Avast Software Updater – It’s a cool feature that informs out of date softwares in your PC and you can quick fix to update all other softwares in easy way.

 Browser Cleanup – Clean unwanted toolbars in your web browsers or you can disable them


 Data Shredder – It allows you to delete or erase your hard disk data completely. This is useful one when you cleaning your personal data that not to be recovered.

 Access Anywhere – This is to create remote administration service if you want to operate your computer from outside. You can access it from anywhere and it will be always online if your system has internet connectivity.

 Avast Ad blocker – This is a cool new add-on introduced in this version that blocks banners, advertisements and pop-ups in your web browsers. With this add-on, you can browse the web safely and freely.

Download new Avast 8.0 Free

What are Best Alternatives for Google Reader?

Google has recently announced that they will retire their popular Google Reader RSS service with some services from July 1, 2013. This will be the sad news for internet users because Google Reader is only the best to read the posts from our favorite sites. Let’s see some alternate ways or services for Google Reader.

Google Reader Alternatives for Web:

1. Feedly – This is good RSS news reader available for Web, Android and iOS devices. It is a responsive site, so you can read the blog list in any devices clearly. They are giving option for transferring your data from Google Reader to Feedly easily. You can sync and transfer your Google reader data until June 30th.

Feedly RSS reader

2. Strymr - It is web based reader with easy navigations and it has thumbnail user interface

3. Taptu – It is also good alternative to Google reader available for all platforms like web, Android and iOS

 Google Reader Alternatives for Mobiles:

1. NewsRob for Android - This app easily sync with your Google Reader account. It will show the unread contents, so you can easily get and read the new items.

2. Feed Me for Android – It supports offline reading.

3. Slide Reader for iOS – It supports many number of feeds and has good user interface.

4. Reeder for iOS – It will also sync automatically with your Google account.

5. FlipBoard - You can read the news by flip, also videos Android | iOS

Download WinX HD Video Converter - Easter Free Giveaway

 Download WinX HD Video Converter - Easter Free Giveaway


Digiarty is a popular DVD ripping / copying software vendor, now running a big giveaway & promotion for the Easter festival. They are giving a time limited offer to download WinX HD video converter software free to all. WinX HD video converter actually worth $49.95, but now you can download for completely free.  
Download WinX HD Video Converter - Easter Free Giveaway
 WinX HD video converter supports all types of media formats such as Mkv, Mpeg, Avi, MP4, Wmv, FLV and etc. And you can play your videos with all media players, iPhone, Android, DVD players and tablets.

Features of WinX HD video converter 

• All in One HD Video Converter helps to convert your videos in HD format
• Burn your DVD videos with DVD burner facility. 
• Download videos from YouTube and more sites online
• Convert videos to all devices like iPhone, iPad, iPod, PSP, Android, etc.
• Unparalleled Video Transcoding Speed for fast converting.
• Supports all media formats
Download WinX HD Video Converter - Easter Free Giveaway
Download your copy of WinX converter software and proceed to share this news on social sites like Facebook and Twitter. Next you will get the activation code for your copy to use the software free for lifetime.

WinX HD video converter free giveaway page

Alternatively you can copy this activation code here - AF-VYEZVSSD-UAYFUX

Note: Activate before April 9, 2013 otherwise you cannot use this software.