I have 2 data ranges in one worksheet that share the same columns and have similar headings and formulas in each one. I recorded a macro and assigned it to a button next to a row of the top data range of the worksheet that I need to copy and insert so that the values of the new row get included in the column totals. I created the same for the lower data range. Here's the problem: When the macro button for the top data range is clicked, the sum formulas in the lower data range adjust for changing cell references and are correct. However, when the macro button for the lower data range is clicked, the sum formulas under each column for this data range revert to its previous formula before the top macro button was clicked. Thus, it omits the first row under the heading. There is not a problem when the lower macro button is clicked before the top button. How can this problem be corrected?

The first button has the following VBA code:
Sub Add()
'
' Add Macro
'

'
Rows("13:13").Select
Selection.Copy
Selection.Insert Shift:=xlDown
Range("A14:D14").Select
Application.CutCopyMode = False
Selection.ClearContents
Range("A14:C14").Select
End Sub

The second button has the following VBA code:

Sub AddAsideRM()
'
' AddAsideRM Macro
'

'
ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select
Selection.Copy
Selection.Insert Shift:=xlDown
ActiveCell.Offset(1, 0).Range("A1:D1").Select
Application.CutCopyMode = False
Selection.ClearContents
ActiveCell.Range("A1:C1").Select

End Sub