Calculating monthly sales goals based on growth to target?

[Pitso Mohlokwane]

Hi guys

I need help with a formula to dynamically re-calculate my target based on the actual input.

1. On the screenshot from c4:n4 the user enters the percentage that must add up to 100%.
2. H8 user enters the yearly target to reach
3. C4:N14 enters the target based the percentages user provides and from c13:n13 user enters the actual amount for the month.

I need a dynamic formula that will re calculate everytime the user enters the actual amount for the month. I have visited this page Calculate Monthly Goal to reach target on stackoverflow and it does exactly what I want but I want it to be dynamic based on the percentage inputs.

[#2]

Can you provide a non-sensitive sample file so that we can better understand your data representation, data structure and the existing formulas?  It will make it easier for someone in the community to assist you with more detail.

[#3]

[#4]

Sorry that is the picture on how the system looks

[#5]

What about if O4 = SUM(C14:N14)-SUM(C13:N13)?

Maybe I'm missing something?