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. |
|||||
![]() |
|||||
$69.95
| 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 $69.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.
Instant Download and Money Back Guarantee on Most Software
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