Just when I was starting to get a basic grasp for VBA!!
Little bit of code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Row = [TotalVal1].Row - 1 Then
Application.EnableEvents = False
[TotalVal1].EntireRow.Insert
ActiveCell.Offset(-1...