# Insert Line; Need formulas to adjust correctly

#### jmcgarbo1

##### New Member
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>

### Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

#### oldbrewer

##### Well-known Member
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

##### New Member
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

##### Well-known Member
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>

Replies
6
Views
225
Replies
10
Views
352
Replies
3
Views
257
Replies
22
Views
472
Replies
1
Views
106

### Forum statistics

1,190,735
Messages
5,982,646
Members
439,789
Latest member
Justhavinaltlfun2002

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back