Thank you very much.

Please help me with Excel formula that update automatically without changing the cell reference manually when inserting new row at the bottom only. But not when inserting new row at the top. Thanks

This is really helpful ... except it does not update the row/column when copying and pasting this formula, so if I have a bunch of them, I have to update the column/row manually (like in the example, if I copy this to the adjacent column E, it still has D ...)

Unless someone knows a workaround to that problem, too?

I have a simple cell reference in one of my cells down a column e.g.:"=H6", “=H7” etc. When I insert a row in Excel and copy formulas from row above, the cell reference in 'Opening Stock' does not update automatically in the row after the new blank row (should be equal to previous row balance, which is 60 now). But it updates correctly in all other rows below. Is there a way to force Excel to update cell reference to the cell in blank row above? Have searched the web, but did not get any satisfactory answer. I do not want to convert the data to a table, since it messes up the filters and formatting. Macros don't solve the problem either - they don't copy to the row following the blank one. Can anyone please help?