The Consolidator Tool will allow you to consolidate spreadsheet data from one or several sheets from one or many open workbooks easily and quickly. This useful tool makes easy the process of to consolidate information proceeding from different workbook. but from the same range.
Click on the Consolidator button.
Click on the workbook(s) you wish to consolidate
Choose the sheets from that workbook and add them using the arrows button.
You will be able to see them in the right field of the dialog box.
The area surrounded by a red rectangle shows the workbooks and sheets to consolidate and the cell/range taken from each sheet.
Choose the mathematical operation you want to perform.
Results can be displayed in three ways, As values, as formulas or as links

Special! Complete Excel Training Course AND Excel Add-ins Collection on this product. Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.
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
Secure Payment 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 & Excel Training Index & Excel Templates Index & Neural Network Software Index Trading Software Index & Charting Software Index Or, All Software
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