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 its 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.