|
| Updated |
Jan 16, 2008 15:44:48 | | Author email | anikolaev@3d2f.com | | Author | Nikolaev Alexander Dmitrievich |
|
|
| More author articles: | - Battery EEPROM Works - a must-have tool for battery and laptop repair services! — When batteries go out of order, it does not necessarily mean that they must be immediately replaced with new ones. As a rule, it’s just a part of the battery that gets damaged, but causes the entire assembly to go defunct. This corrupt segment can be replaced by a skilled technician who is good with a welder in minutes, but then it’s the battery software…
- Search Assistant - a new way of searching your computer for the necessary information — The standard Windows search function has always been a moderately useful tool for finding files with names that you remembered and text in indexed documents. However, each time you needed to find something deeper under the surface, the process turned into a real challenge. The standard Windows search is far less flexible and powerful than most query engines, so you cannot combine search parameters to find…
| | Show all author articles |
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 don’t 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.
Author: Nikolaev Alexander Dmitrievich | |
| | Learn more about ConsoXL… |
|
|
