I have a macro that advance filters some data according to a criteria range, and then places the desired fields in a data table on another worksheet.
The advanced filter code is straight forward and works fine, but I notice that unlike when I simply copy and paste data into a data table, in this case the table doesn't automatically expand to accomodate additional rows. For example, if an existing table called "Table1" is 10 rows long, and my filtered data is 15 rows long, the first 10 rows of the filtered data populate the table as desired, but the 5 remaining rows are simply pasted below and outside the Table1 range (so unable to filter/sort, etc.) .
The advanced filter code is straight forward and works fine, but I notice that unlike when I simply copy and paste data into a data table, in this case the table doesn't automatically expand to accomodate additional rows. For example, if an existing table called "Table1" is 10 rows long, and my filtered data is 15 rows long, the first 10 rows of the filtered data populate the table as desired, but the 5 remaining rows are simply pasted below and outside the Table1 range (so unable to filter/sort, etc.) .