Sep 28 2022 03:24 AM
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.
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)
I then want the original data to be deleted, and the table sorted by the following criteria
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
Sep 28 2022 06:58 AM
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).