Copy data from one sheet to bottom of table

Copper Contributor

I'm trying to make a sheet where I can input a line of data, press a button, and it gets copied to the bottom row of a table in another sheet.

Jeremy1565_0-1664360314914.png

This is the field I want to enter my data in (Row 2 of sheet "Matrix view")

And I want it to be pasted to the bottom row of "Table3" in another worksheet (Training matrix)

 

Jeremy1565_1-1664360450667.png

 

I then want the original data to be deleted, and the table sorted by the following criteria

Jeremy1565_2-1664360533009.png

I'm fairly new to macros, I can do basic stuff like copying, pasting, deleting and sorting, but finding or creating the bottom row of a table and pasting something in it is a bit beyond me

1 Reply

@Jeremy1565 

 

Is it possible for you to post the actual workbook--if not here in this forum, then on OneDrive or Google Drive, posting a link and granting access here. 

 

For what it's worth, it might be possible to accomplish what you're doing with some of the newer Excel Functions, without resorting to macros. But working with the actual workbook would verify that (or disprove it).