Few clicks consolidation
Step 1:
You are working on the plan for next year and you've build up an Excel file which contains 2 sheets:
- P&L
- Manpower
You send this file to all the departments/divisions/branches...
They carefully fulfill it and send it back just on time (
it may happen!
)
Step 2:
So, it's time to consolidate:
- Click 1 start ConsoXL
- Click 2 start Windows explorer (or click the
) -
Click 3 select the Excel files you've received.
- Click 4 on the Conso button:
The consolidation works...
Step 3:
Now you have an Excel file with:
- The consolidated P&L and the sheets of all departments
- The consolidated Manpower and the sheets of all departments
- A ConsoXL sheet which is the consolidation report summarizing consolidation data.
If you've used the default options of the demo project, the P&L sheet may look like this:
With the total, the details and the links.
If we look at the percentage cell:
The formula is still there.
All the sheets are grouped in the same workbook :
