[Button] Insert row below, copy the formulas and make them correct.

Good day dear friends,

I would like to ask you for assisting me in my problem.
For the last few days I am trying to add a button that will insert a row below the button and copy/stretch the formulas on all the rows.
When I just insert a row, the formulas on column L and M are not coppied right and I get a green arrow in the left up corner so i can correct it.
Problem is that i want to hide the M and N columns & don't want to correct it every time i insert a row.

I couldn't find any solution on the internet :<

---

I have this formula, but seems like its not working and i just dont know why.

Please Login or Register  to view this content.

Thank you all in advance!

Szymon

1. Please use code tags when posting code (see my footnote on how to)

2. Have you considered using Structured Tables for this? When you add a new row of data, the formulas automatically populate the new row