|
Distributing divisional budgets
|
How to distribute divisional budgets to departmental managers using Master Budgets.
|
|
1. Move each budget spreadsheet into separate files (one for each department or manager) using Excel's Edit/Move or Copy command.
2. Email each budget spreadsheet to each manager for them to complete their budget figures.
3. Request them to send their respective files back to the "mother" system holding the original Master Budget file.
4. Arrange that all these satellite budget files are open in the Mother system to consolidate all budgets.
5. You will receive a default update request message each time you open your Master Budgets. Click "Yes" to update values.
|