Hi Everyone
Looking for some assistance with either a formula or VBA code to do the following:
For simplicity, Sheet 1 contains 2 columns. Column H is 'Implementation Date and Column O is 'Dev Headcount'
Sheet 2 contains a chart spanning over 20 months.
What I am trying to do is build a headcount forecast based on new projects added to sheet 1. Each project takes roughly 7 months to implement and the headcount effort breakdown for each month is below
Month 1 3.0%
Month 2 14.0%
Month 3 17.0%
Month 4 21.5%
Month 5 21.0%
Month 6 17.5%
Month 7 6.0%
I need Sheet 2 to recognize when there is a new entry on Sheet 1. Further to that, I would need the total headcount to be broken down based on the Implementation date and the 7 months leading up to it based on the % breakdown above. I would need this continuously summed on the same row 19 Sold Capacity - BAU on Sheet 2 as more entries are added on Sheet 1.
Sample pictures are attached.
Let me know if you need any more info.
Sheet 1
Sheet 2
Looking for some assistance with either a formula or VBA code to do the following:
For simplicity, Sheet 1 contains 2 columns. Column H is 'Implementation Date and Column O is 'Dev Headcount'
Sheet 2 contains a chart spanning over 20 months.
What I am trying to do is build a headcount forecast based on new projects added to sheet 1. Each project takes roughly 7 months to implement and the headcount effort breakdown for each month is below
Month 1 3.0%
Month 2 14.0%
Month 3 17.0%
Month 4 21.5%
Month 5 21.0%
Month 6 17.5%
Month 7 6.0%
I need Sheet 2 to recognize when there is a new entry on Sheet 1. Further to that, I would need the total headcount to be broken down based on the Implementation date and the 7 months leading up to it based on the % breakdown above. I would need this continuously summed on the same row 19 Sold Capacity - BAU on Sheet 2 as more entries are added on Sheet 1.
Sample pictures are attached.
Let me know if you need any more info.
Sheet 1
Sheet 2