Hello forum,

I have an excel file where I paste raw data into a table and it expands automatically, depending on how much data I paste in as usual with tables. This tab is called "Raw Data". Beside this I have a tab called "Processed Data" in which I have another table where I have multiple functions to create multiple metrics from this raw data.

What I want to achieve is to have the same number of rows in the processed data table as in the raw data table. As the processed data table contains functions, it does not expand automatically.

Is there a way to let excel expand the second table automatically to have the same range as the first table?

Example: In the "Raw Data" table, I pasted 75 rows of information. When I go to the "Processed Data" tab, I want the range to be 75 rows as well. (The number of columns hereby stays the same).

Don't hesitate to write me if you need more information.

Thanks in advance for the help!

Best regards,
Adam