Copy data from a filtered table to another table in another sheet and resize the table to avoid spill error

[OttoV]

Hi everyone, after much searching I found this forum. Really need your help.

I have a workbook consisting of two sheets.

Sheet 2 - data that comes from a filtered table. basically each cell has a formula that pulls values from another table. It could be 1 row, or it could be 100 rows depending on a cell value (client name) in Sheet 1.

Sheet 1 - has a table, lets call it Table1 that needs to pull all the values from sheet 2. However, below Table1 there needs to be additional data. I need Table1 to be resized depening on how many rows there are in Sheet 2 and then import that data into Table1. Otherwise I get a spill error.

Hoep there is enough information here to point me in the right direction.

thanks for all your help!

 

[skillilea]

OttoV

Welcome to the board!

To get the best help it's preferred if you install the XL2BB plugin. This will allow you to copy your sheets directly into a comment. Asking members to recreate tables and experience is a tuff ask.

Couple of first steps:
Copy your filtered data
Find the last row of your table (assuming it's an excel table) add 1
Paste directly below it.
The table will auto resize itself