|
| Updated |
Jan 16, 2008 15:44:48 |
|
|
Once upon a time, spreadsheet software has changed the business world. Now, a typical business-process is almost unthinkable without Microsoft Excel (or something similar for other platforms). But sometimes (not so rarely, in fact), there are calculating tasks that seem to be monotonous enough for a good automation, but the common spreadsheet features dont play well with this kind of automation. A good and frequent example of it is the sheet-wide summarizing: You have several sets of data in several workbooks (for example, results of experiments, or reports from departments), and you need compile a consolidated workbook. How? Two ways: 2 hours of hand-work or 2 minutes with ConsoXL.
ConsoXL is like a small piece of powerful magic. You add several workbooks to the list for the consolidation (easily including and excluding individual worksheets if necessary); now you can just press the Conso button. The result is the summary workbook having all sheets from the source workbooks and the special consolidated sheet (or sheets, for each sheet of source workbook).
The consolidated sheet has not only the summary formulas, but also handy comments, so you have all the sums and their components available in-place. A few ConsoXL settings make it flexible enough for virtually any variation of workbooks consolidation. | | | Learn more about ConsoXL… |
|
|