Aggregate all the data in corresponding spreadsheets across any number of workbooks and create new workbooks holding their consolidated data in the same spreadsheets.
Add, slice, and report data across workbooks with an unprecedented ease.
Add the data in all of the cells in all of the spreadsheets across any number of workbooks in one step, without all the drama.
Excel files holding input data and those holding merged data are assembled just like the files and folders in a tree structure. An application can have multiple structures adding up the same files in different ways.
The ability of MergeXL to carry the results of some calculations forward into merged workbooks instead of the formula, the first step in real consolidation is effected. Multiplications or cells linked within a workbook show the correct result no matter the level of consolidation viewed.
MergeXL also allows a workbook to be designated to hold credit values and offers a protocol for automatic inter-company eliminations. These are further steps in financial consolidation.
MergeXL takes the data from ordinary Excel files and places their merged data into new, ordinary files. No additions or links are used. As many files as you like.
All of the Excel workbooks remain free standing, independent files.
The corresponding spreadsheets in each workbook are added together, with the merged workbooks having the same spreadsheets of the source workbooks, but holding the merged data.
Excel files, both source workbooks and merged workbooks, can be added and moved around in a few seconds. Making changes or adding new workbooks is a snap.
The yellow folders above are Excel files into which MergeXL places the merged data from the Excel files beneath them. These folders represent levels of consolidation.
There can be any number spreadsheets in the files, any number of workbooks in a structure, and any number of merged levels, nested to any depth required.