I want to provide Managers in the organisation with a Budget template for each department they are responsible for.
The green area in the attached area is the historical accounting data from a DB. The grey area is the Budget data subsequently entered by the Manager.
The managers would receive the historical data (Green) of the Department they key in (Cell H8) and then work through each row inputting the data in the grey area The plan is to pull all the Budget input into a Data Model that would also include the historical accounting data.
Note - Input would only be allowed in the grey area. New rows and \ or Departments could also be added by the Manager and not every Department has the same Accounts and neither will all rows will have historical and/or budget data.
My question is - how would I go about providing the template in a way that allows input from the manager. I am not sure but I think PowerBI might be the most robust way to approach this.
I would welcome your thoughts and ideas.
Book102.xlsm (12.3 KB)