Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Smart Consolidation in Excel

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Tools for Excel Tables Start

Multi sheet / database consolidator  
Do you wish to consolidate data come from many sheets contained in more than one workbook?
and, besides, the records are disordered?
Then, this tool will make it for you.
Let's see an example:
Suppose, that I want to consolidate data contained in 2 workbooks,
These workbooks are named: "Example_01.xls" and "Example_02.xls" respectively.
In order to use this tool, first, I must name to each range to be consolidated.
In this example, the ranges' names are the following ones:



See the named ranges to use:






Then, we open the corresponding dialog box (showed below)
We choose the names that we will use in the consolidation and we finally press on Ok button for to execute the action.



Note that if the selected named range(s) is located in workbooks different, then the consolidation will be done in a new workbook.


The result is a pivot table con the wished consolidation.
If we had chosen "Paste results as... Static table" then the results would be showed in a simple table.


Back to Tools for Excel Tables Start

Tools for Excel Tables    Secure Payment Options

1 $89.95 USD
2 - 5 Licenses $79.95 USD
6 - 9 Licenses $72.50 USD
10+ Licenses $54.95 USD

Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site.

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us