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)