Insert Line; Need formulas to adjust correctly

[jmcgarbo1]

Hi all, I have a spreadsheet(condensed version) that I need help with formulas changing...
Every month I insert a row for the new month between Nov & Cur Mo vs Ls Mo, the formula B9 changes from B7/B8 to B8/B7(same idea with the other formulas) but I need it to now be B9/B8(ie, Dec/Nov)... so I tried instead to insert between Oct & Nov and that solved the formula problem with YOY and CM vs Budget but Cur Mo vs Ls Mo still was incorrect...and changed to B9/B7 ... need it to be =B9/B8...Is there a way to get both sets of formula's to update correctly in one step or quickly??? I have a lot of lines and spreadsheets that require this action frequently. Thanks

Cycle MONTH Formula in Cells Last FY $2,000 Budget $2,601 Jul $1,500 Aug $1,800 Sept $2,501 Oct $2,300 Nov $1,500 Cur Mo vs Last Mo % 65% B7/B6(Nov/Oct) Cur Mo vs Last Mo $ $(800) B7-B6(Nov-Oct) YOY% (M) 75% B7/B3(PY/Nov) YOY $(M) $(500) B7-B3(Nov-LastFY) CurMo vs Budget $(1101) B7-B4(Nov-Budget)​ <tbody> </tbody>

<tbody>
</tbody>

 

[oldbrewer]

Hi all, I have a spreadsheet(condensed version) that I need help with formulas changing...
Every month I insert a row for the new month between Nov & Cur Mo vs Ls Mo, the formula B9 changes from B7/B8 to B8/B7(same idea with the other formulas) but I need it to now be B9/B8(ie, Dec/Nov)... so I tried instead to insert between Oct & Nov and that solved the formula problem with YOY and CM vs Budget but Cur Mo vs Ls Mo still was incorrect...and changed to B9/B7 ... need it to be =B9/B8...Is there a way to get both sets of formula's to update correctly in one step or quickly??? I have a lot of lines and spreadsheets that require this action frequently. Thanks

Cycle MONTH Formula in Cells Last FY $2,000 Budget $2,601 Jul $1,500 Aug $1,800 Sept $2,501 Oct $2,300 Nov $1,500 Cur Mo vs Last Mo % 65% B7/B6(Nov/Oct) Cur Mo vs Last Mo $ $(800) B7-B6(Nov-Oct) YOY% (M) 75% B7/B3(PY/Nov) YOY $(M) $(500) B7-B3(Nov-LastFY) CurMo vs Budget $(1101) B7-B4(Nov-Budget)​ <tbody> </tbody>

<tbody>
</tbody>

can you put in the next 24 months now with the correct formulas in place so that when cells go from blank to containing data the formulas spring into action ?

 

[jmcgarbo1]

Not really .. the data is tied to charts as well so I would then have to update the data source for the charts as well... that can be even uglier

 

[oldbrewer]

Not really .. the data is tied to charts as well so I would then have to update the data source for the charts as well... that can be even uglier

Jul	1500
Aug	1800
Sept	2501
Oct	2300
Nov	1500
Dec	1700.00
curr/last%	1.13
curr/last$	200
				before adding Dec
				Jul	1500
				Aug	1800
				Sept	2501
				Oct	2300
				Nov	1500
				curr/last%	0.65
				curr/last$	-800
				I merely copied last 2 rows from 6 and 7 to 7 and 8
				then overtyped the Dec figure

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>