Okay let's try and just update your original spreadsheet:
Open your original document. Not the one I gave you.
In cell E5 type =C6+11 (since the number of rows that are currently being used before the dates are 11 rows)
In Cell A11 type =C4 (the start date)
In Cell A12 type =DATE(YEAR(A11),MONTH(A11),DAY(A11)+1)
Select Cells A13:A38 and press the delete key to clear the contents. Make sure to not delete the formulas in Cells A11 and A12.
Then go to the Developer Tab and select the Insert option from the Controls. Select the Command Button under the ActiveX Controls.
Draw a button above the table. I put it above the Date and Beginning Daily Balance cells.
Right click on the button and view code.
Copy and paste the following code in between the Private Sub and the End Sub
If Range("C4") = "" Then
Exit Sub
Else
Range("a12:H12").Select
Range("a12:h12").Copy
Range("a13:h" & Range("e5").Value).PasteSpecial
End If
In the end it should look like this
Private Sub CommandButton1_Click()
If Range("C4") = "" Then
Exit Sub
Else
Range("a12:H12").Select
Range("a12:h12").Copy
Range("a13:h" & Range("e5").Value).PasteSpecial
End If
End Sub
Exit out of VBA
Unclick the Design Mode Button under the developer tab. Then click the command button to see if it works.
If it works you'll need to save it as a macro-enable document.
Let me know if it works for you!
Thanks!
Bookmarks