I have a column of numbers follow by two blank rows then a calculation
using the last entry in the column.

How do I reference the last data entry?

When I insert a new row and copy the formulas the formula below the
blank rows doe not adjust.

Thanks in advance.

CW