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
Pricing:
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