Hi thanks for the reply,
I would just like for the calculations in the new rows to work. For example when I click 'Add' and a new row is created, the 'net' column to calculate the sum.
In the case of the 3rd row it would be. "=SUM((E3/100)*F3) "