Hi
I am currently trying to create a formula that will change my targeted hours based on the actual hours that I complete each week. For example I have 300 hours split evenly over 52 weeks to give me my target hours for each week. Column A shows the week number, Column B shows the targeted hours for the week, Column C is where I input the actual hours completed. When I input the hours in column C I need the target hours for the remaining weeks to change so that I can see if they are on target to achieving the 300hrs in the year.

I did try a formula that calculated total targeted hours minus actual hours completed and then divide by the remaining weeks but my formula also changed the historical data so I am a bit stuck. If anyone could assist and provide me with the correct formula I would be very grateful. Thanks