Macro paste range to next available row

[Susan Martha]

I only know how to run and record. Trying to create button that pastes a preceding range to next available row, where every time the button is selected, in repeats same operation but to next available row: highlight row 1 - 10, paste to row 11. Hit button again, highlight row 11 - 21 and paste to row 22. This sequence would repeat every time the button is hit. I know how to set-up buttons, just not sure how to write the code.

 

[SteveO59L]

do rows 1-10 contain data?
pasting rows 1-10 to row 11, the data would end at row 20, not 21?

 

[Fluff]

Hi & welcome to the board.
This will copy the last 10 rows to the next row, based on the last used cell in col A

Sub CopyLast10Rows()

   With Range("A" & Rows.Count).End(xlUp)
      .Offset(-9).Resize(10).EntireRow.Copy .Offset(1)
   End With
   
End Sub