Append a previously saved table, or the contents of a worksheet in the same workbook, to the current table in memory.
Append From Table – select a previously named table from the drop down list. To save a table in memory, use TableName.
Select a table from the dropdown, or get the table name to use from a worksheet cell reference.
Append From Worksheet– select a worksheet name from the drop down list. Note that the worksheet must contain data in columns with a header row starting in cell A1. The entire worksheet will be appended.
Select a worksheet from the dropdown, or get the worksheet name from a referenced cell.
Related: Using the Append Function