Row 1 has labels. Row 2 is blank. Row 3 is column headings. Row 4 starts data. Row 14 is Totals of columns. How can I insert a new row that will contain my formulas and add this new row to the totals?
in B15 use =SUM(A4:OFFSET(B15,-1,0)
which allows you insert a row immediately above the total
and have it incorporated into the total without changing
any formulas yourself. It also allows you to any rows
from 5 through 14 without changing the formula..
More information is included on my webpage Frank pointed to
Insert a Row using a Macro to maintain formulas
Why must we use that funny looking OFFSET Worksheet Function (#offset) http://www.mvps.org/dmcritchie/excel/insrtrow.htm#offset
