VBA Inserting line with formulas of previous line automatically between heading and sum totals

[oblix]

Can someone please help
I Have a heading, lines of information with formulas and totals at bottom.
I would like vba code to insert next line for information with previous line formulas added automatically, but must move down my totals line.
in short line inserted between last info and total line.
pls assist

 

[KolGuyXcel]

Try this. This assumes your existing table begins at A1 and will insert 1 row just before the totals line at the bottom and copy the information from the row just above.

Sub ins_row()
Dim LastRow As Long, LastCol As Long, i As Long

LastRow = Cells(Rows.Count, 1).End(xlUp).Row
LastCol = Cells(1, Columns.Count).End(xlToLeft).Column

Range("A" & LastRow).EntireRow.Insert
For i = 1 To LastCol
Cells(LastRow, i) = Cells(LastRow - 1, i)
Next
End Sub

 

[oblix]

Thank you will try as soon as possible