Hi,

Try This:

A B C D E
1 Mounth FC
2 jan 100
3 feb 80
4 mar 120
5 apr 100
6 may 100
7 jun 70
8 jul 130
9 aug 100
10 sep 100
11 oct 100
12 nov 150
13 dec 50
14 Total 1200

in the cell D2 enter: =C2

in the cell D3 enter:
=IF(C3<0,C3,IF(SUM(INDIRECT("$B$2:B"&E3))=SUM(IN DIRECT("$C$2:C"&E3)),B3,ROUND(B3+(SUM(INDIRECT("$B $2:B"&E3))-SUM(INDIRECT("$C$2:C"&E3)))/(12-$C$15),0)))

in the cell E3 enter: =IF(C2<0,ROW()-1,E2)

in the cell C15 enter: =COUNT(C2:C13)

copy and drag formula in cell D3 to D13

copy and drag formula in cell E3 to E13

if you enter actual amounts in column C it adjust the remaining next months.

hope this will work for you.

Thanks,


--
Farhad Hodjat


"diaare" wrote:

I have a speadsheet that forecasts the number of parts built each month for
2007. I would like to replace each months forecasts with actual production
numbers, and then have the speadsheet adjust the remaining months forecasted
numbers accordingly in order to keep the total annual forecast the same.

EX:

FCJan = 100
FCFeb = 80
FCMarch = 120
FCApril = 100
FCMay = 100
FCJune = 70
FCJuly = 130
FCAug = 100
FCSept = 100
FCNov = 150
FCDec = 50
FC2007 = 1200

If actual Jan is 320 then each month thereafter would have to decrease by 20
parts in order to compensate the overproduction in Jan.

Can I create formulas that will still work as I place actual data in each of
the months throughout the year.

Thanks
-Diane