Jepib ConsoXL 1.3.0.0 | 6.3 MB
ConsoXL the quickest way to consolidate excel sheets. If you send out spreadsheets to affiliates, branches, departments…and later need to consolidate them all, or if you simply need to consolidate identical sheets, ConsoXL will save you hours of work. When you create an Excel file format to be fulfilled and want to consolidate all the files, you need to repeat over and over the same Excel operations, sheets and cells selection, copy etc. When a file is changed or updated the process has to start again. This is a time consuming activity and error-prone. ConsoXL has a different approach. Instead of asking you to select each sheet and cell and apply a formula it will build the consolidation model by analyzing the content of the files. It uses by default the sum function for all numbers and keeps formulas. Therefore the only remaining thing to do is to determine how to group the sheets. Most often as they come from the same initial form they have the same name, the filename being the name of the department, branch etc. This is much faster than making manual selection and it’s safer in the sense that no cell will be left aside.