Spreadsheet Consolidator

Consolidator Tool

Spreadsheet Consolidator Start

 Consolidator Tool  

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

Finally, press the Consolidate button and the results will be displayed.

Back to Spreadsheet Consolidator Start