OK so trying to create a "Spend Profile" template to track spend versus budget that I can use for each project that I have and will have in the future.
I have created a sheet to capture basic information for the project (name, approved budget, start date, end date, etc.) and a "spend profile" table to track costs against budget.
The start and end dates are where I have my problem.
For simplicity I am maunually setting up each spend profile table. I show a column for each month that the project runs and a line for each spend item no rocket science here.
I would love to be able to just enter the start and end dates of the project and have the table columns auto populate to include not only a header showing the month in question but the calculations in the summary cells. I.e. if the project is 6 months long I would like see 6 columns only and my total and sub-total calculations would automatically adjust for this.
Any ideas or am I creating a problem that is too big to justify the efforts versus reward to solve?
Thanks
I have created a sheet to capture basic information for the project (name, approved budget, start date, end date, etc.) and a "spend profile" table to track costs against budget.
The start and end dates are where I have my problem.
For simplicity I am maunually setting up each spend profile table. I show a column for each month that the project runs and a line for each spend item no rocket science here.
I would love to be able to just enter the start and end dates of the project and have the table columns auto populate to include not only a header showing the month in question but the calculations in the summary cells. I.e. if the project is 6 months long I would like see 6 columns only and my total and sub-total calculations would automatically adjust for this.
Any ideas or am I creating a problem that is too big to justify the efforts versus reward to solve?
Thanks