Excel for Mac 2011 Macro Button to create new row and autofill

[cda0608]

Hi everyone,

I am new to VGA, but I really need to get this button to work.

I have a sheet with different tables. In my second table, I have 4 rows and 2 columns. The first column says 1st, 2nd, 3rd, 4th, and the second column is blank (besides having a thick border) for the user to fill in. Underneath the table I have placed a button, and have assigned a macro to that button.

I would like the button to make a new row above it and below the last row of my table, it must also autofill the first column with 5th,6th,etc. I can get the button to autofill 5th. Thereafter, if I pressed the button again, it adds a new row but keeps filling in 5th, because it does not have dynamic code to understand that it cannot keep referencing the 4th row.

Can anyone help?

Thanks!

 

[cda0608]

Sub Macro9()
'
' Macro9 Macro
'


'
Rows("16:16").Select
Range("B16").Activate
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Range("B15:C15").Select
Selection.AutoFill Destination:=Range("B15:C16"), Type:=xlFillDefault
Range("B15:C16").Select
End Sub

 

[cda0608]

Not sure how to attach a photo, so an image of the problem can be found here: https://www.dropbox.com/sh/d2rh0wr3zziptx2/AAAl9YFGLRWZyZ267l6203Sia?dl=0

Please help!