I'm working on a spreadsheet wherein I need to auto copy the formula from the above cell to the new cell below which is technically a new row.
Attached is a snapshot on what I have in excel using the formula in column "H" =SUM(H2,F3,-G3) to calculate the BALANCE column.
So based on my example, if a new row is inserted in Row 8 the formula in cell H8 should be =SUM(H7,F8,-G8) this should be automatically inserted.
Is there a way I can do this automatically?
TIA!