Software Search, Categories and Specials Similar Products
Consolidate Excel Files
Merge Excel Files
Consolidate Excel
Consolidate Enterprise
Advanced Consolidation Manager
Spreadsheet Consolidator
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

Detailed Consolidation

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

Buy Today (below) and send us your order ID and claim over $70.00 worth of FREE software

 

Spreadsheet Consolidator Start

Detailed Consolidation

 
This type of consolidation is appropriated if you want to see the detail along with the totals

Let's illustrate this tool's performance through a didactic example.

Suppose we have a workbook called "Products", this workbook possesses 6 sheets with following names: "Coffee", "Beverage", "Chocolates", "Fruits", "Others" and the sixth sheet is called "Detailed Consolidation". Also, five of these sheets shows the sales total of a determined product. See the below image:

 
 
 
And so on.

 

Now we click on Detailed Consolidation button and add the 5 sheets we wish to consolidate (less the Detailed Consolidation sheet)
From now on, we proceed to choose the range to consolidate (this range will be the same for each sheet)

This way:

 
 
Likewise, we have chosen the place where the results will be pasted
Press on Consolidate button and we will see that the Detailed Consolidation sheet shows the following result.
 

Back to Spreadsheet Consolidator Start

Details & Screen Shots: Consolidator > Consolidator (Creating models) > Consolidator (Existing Models) > Consolidator (Copy models from: ...) > Multi-Sheet Consolidator > Detailed Consolidation > Export sheets as ... > Toggle settings > Freeze | Divide panes

Video Tour  More > Consolidator Demo > Merge Tables Demo > Multi-sheets Consolidator Demo

Spreadsheet Consolidator     Secure Payment Options

Requirements:  Excel 97 or higher and Windows 98 or above
Pricing:  
1 $74.95 USD
2 - 5 Licenses $63.95 USD
6 - 10 Licenses $56.95 USD
11+ Licenses $37.95 USD

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours

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

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

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