Adding new row and automatically calculating the total amount at the bottom

[eazyyexcel]

Hello there,

Is there a way I could add a new row at the bottom of the table (just before the total sum), key in the new data and the final total will be automatically calculated? Currently I need to add a new row manually, then I copy and paste the previous row and I paste in the new row, delete all the data, and key in the amount. But I notice the total sum at the bottom is not being automatically calculated. I need to reformat the formula to add the calculations of the new row.

Would really appreciate anyone's help on this.

Thank you

 

[LazyBug]

Hi I have attached my file.

Hello! Maybe "one-click" VBA solution will suit you, in that case try this macro on a copy of your data. If i understand correctly, data for sum begins in the row 4. Macro inserts a new row to key in a new data at the bottom of table with SUM formulas amending in the D, F, H, I, J columns.

Sub ezxl()
Dim lr&, arc(), i&
Application.Calculation = -4135

arc = Array(4, 6, 8, 9, 10)
    With ActiveSheet
        lr = Cells(4, 4).End(4).Row
        Rows(lr).Insert
        For i = LBound(arc) To UBound(arc)
            Cells(lr + 1, arc(i)).FormulaLocal = "=SUM(" & Range(Cells(4, arc(i)), Cells(lr, arc(i))).Address & ")"
        Next i
        Cells(lr, 4).Select
    End With
   
Application.Calculation = -4105
End Sub