Hi
I download a table each day, but I need it to be added to the bottom of another table, I've found the following code to add the rows but I can't seem to get it to work...can someone please explain how Listrows and Listobjects work, and what Open_items and Closed_Items refer to?
http://stackoverflow.com/questions/1...-another-table
Dim srcRow as Range
Set srcRow = ActiveSheet.ListObjects("Open_Items").ListRows(i).Range
Set oLastRow = Worksheets("Closed").ListObjects("Closed_Items").ListRows.Add
srcRow.Copy
oLastRow.Range.PasteSpecial xlPasteValues
Application.CutCopyMode = False
Rows(i).EntireRow.Delete
My worksheets are "Data table" (source) and "Defects" (destination)
Bookmarks