You want the inserted-in-the-middle row to pick up the formula from above and
all rows below to update their references.

See David McRitchie's site for "InsertRows"

http://www.mvps.org/dmcritchie/excel/insrtrow.htm


Gord Dibben MS Excel MVP

On Sun, 3 Feb 2008 11:45:00 -0800, wolfv
wrote:

Joel,

Thank you for the quick response. Your method works for inserting a new row
to the end of a column of formulas.

I am inserting a new row into the middle of a column, so the row immediately
below the new row needs to change it’s reference to the new row.


"Joel" wrote:

You can copy the last row of data and then insert copied cells. then put new
data into of new last row of data. The formulas will automatically update

I highlight the last row of data and then right click the row and insert
copy cells above the present row.