Button for duplicating the last row on a table?

[Endoerean]

Hey! I just found you guys looking for a solution for this specific problem I have:

I have this simpe 1 column table, I need a macro I can put in a button, in a way that On press, It duplicates the last row of my table (Name Table1) expanding the table itself down below with one more row containing the same formula as the row above, Ideally being able to repeat this process.

Would anyone lend me a hand? I would Really apreciate it! Thank you!

 

[Peter_SSs]

Welcome to the MrExcel board!

Does this do what you want?

Sub Add_Row()
  ActiveSheet.ListObjects("Table1").ListRows.Add
End Sub