Hi. I found the below code that copies selected rows to another sheet, outside of a table.
Code:
Selection.Copy Sheets("Edited").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
I would like the code to move the selected rows from table "tForEdit" of Sheet "ForEdit" to the first empty row of table "tEdited" in sheet "Edited".
Presently I am using this code. After running the code, I delete the selected rows, then resize the table to include the rows added.
An advance thank you for the usual help.