Move entire rows from one table to another table

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Move entire rows from one table to another table

FAQ

Thread Tools

Display Modes

11-03-2021, 12:07 AM

Marcia

Windows 10 Move entire rows from one table to another table

Office 2019

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

Move entire rows from one table to another table

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting Blank Space between table heading and table rows	Pete Jones	Word Tables	5	01-22-2018 04:11 PM
Duplicating one or more table rows or an entire table with content controls	kevinbradley57	Word VBA	10	08-17-2017 02:13 PM
Move table cell contents from one table to another table or cell in same table	donaldadams1951	Word VBA	4	02-04-2015 03:54 PM
Is it possible to copy non-contiguous rows of a Table and paste them as a separate Table in Word?	Joey Cheung	Word Tables	1	08-12-2014 05:15 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM