HOME Excel  |Software |Excel Formulas |Excel Macros |FreeExcel Help |Excel Training |Excel Development |Newsletter |SEARCH |Contact Us

Detailed Consolidation

Spreadsheet Consolidator is an Excel add-in which will allow to consolidate spreadsheet data from one or several sheets from one or many open workbooks, easily and quickly.

30 Day Money Back Guarantee

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.
 

Spreadsheet Consolidator Start

Details: 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>Consolidator Demo >Merge Tables Demo >Multisheets Consolidator Demo >Detailed Consolidation

Spreadsheet Consolidator  $69.95 30 Day Money Back Guarantee Payment Problems/Options

System Requirements: Excel 2000 or above and Windows 98 or above
License Type  Cost
1 $69.95 USD
2-5 $59.45 USD
6-10 $52.46 USD
11+ $34.95 USD

Special ! Free Choice of Complete Excel Training Course or Excel 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. Send payment proof to special@ozgrid.com 31 days after purchase date.

See Also: Excel Add-ins Index or, All Software


Instant Download and Money Back Guarantee on Most Software

Excel Trader PackageTechnical Analysis in Excel With $139.00 of FREE software!

Add to GoogleSearch Tips FREEExcel Help

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