Self Ajusting cell , moving to provide target to meet end of year target

I imagine the Moderators will want (insist) that you change your thread title to comply with forum rules.

As Ali has said, be explicit and post a sample workbook. In principle, the adjusted weekly target would be the average of the annual target, less sales to date, averaged over the remaining weeks.

I'd suggest you increase your annual target by, say, 10% to give you some room for manoeuvre if you have a bad week or two towards the end of the year. There might not be scope to cater for late under achievement.

Hi, sorry if ive not met some rules. I've attached a simple sheet to show what im being asked to do.

I want he cell to review the results already entered and then provide a live target to meet end of year target. I understand the live target will decrease if some results are above but cannot figure the formula out

Thanks

Andy

Can't post sample workbook - sorry.

See if this helps:

	B	C	D	E	F
3	End of year target	3.58	Week Number	1	2
4	3.74		Input Data	1.57	4.33
5		I need the cell above to provide an updated target to meet each week so by year end the end of year target is below 3.74	Initial Target	3.74	3.74
6			Running Target	3.74	7.48
7			Achieved	1.57	4.33
8			Running Total	1.57	5.90
9			Running Average	1.57	2.95
10			Running Difference	-2.17	-1.58
11			Revised Target	3.78	3.77
12
13
14			Week Number	E3	week number as presented
15			Input Data	E4	weekly achievement data
16			Initial Target	E5	=IF(E$4="","",$B$4)
17			Running Target	E6	=IF(E$4="","",N(E$3)*N($B4))
18			Achieved	E7	=IF(E$4="","",N(E$4))
19			Running Total	E8	=IF(E$4="","",SUM($E$7:E$7))
20			Running Average	E9	=IF(E$4="","",SUM($E$7:E$7)/E$3)
21			Running Difference	E10	=IF(E$4="","",SUM($E$7:E$7)-N(E$3)*N($B4))
22			Revised Target	E11	=IF(E$4="","",(52*$B$4-(SUM($E$7:E$7)-N(E$3)*N($B4)))/52)
23			What you want …	C3	=INDEX($E$11:$BD$11,COUNTA($E$4:$BD$4))