Transfer current row of data (Table) to a new row in a second table on the same sheet

[jrtraylor]

Ok I am having trouble getting transferring a row of data from one Table to another using a button. I use the code (and various versions of it) listed below successfully from worksheet to worksheet and even from one workbook to a separate closed workbook. But cannot seem to figure out how to do it from Table2 to Table3 when both tables are on the same sheet.

I have attached a workbook that has 6 tables on one sheet. I need to transfer the current selected row from table 1-2, 3-4, and 5-6. Then delete the current selected row from the primary table.

Please Login or Register  to view this content.

I am not having any luck modifying the above code to work with tables on the same sheet. Any help with modification of the code, to
Copy the values of the current selected row
Insert a new row at the end of the second table / Add data to the next available row (NOTE I would like to add the row if the table does not have any rows left to use).
Delete the current selected row from the first table.

[millz]

Hi, try this. Select the cell in a table and click 'Transfer to Submitted/Closing' to move that particular row to the next corresponding table.

[jrtraylor]

Exactly what I was looking for. Thanks for the quick response.