Is there a way to link multiple table ranges togehter?

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

Hello mikeTRON and thanks for your comment!

I cannot do that because of safety reasons so that the processed data doesn't mess up the raw data... The processed data has to be separate, e.g. in another tab.

Could you describe a little bit further how I can do that with the data model or send me a link to a tutorial? I would be very thankful!

Have a nice day!

Adam

Hey mikeTRON,

well, by safety I mean not messing up the file when pasting. The file will be used by a lot of people and I just want to ensure that it has the least probability of issues possible...

However, I tried to create a copy-paste macro and it worked! Thank you very much for the suggestion! I used this simple line of code for this:

Worksheets("Raw Data").Range("Copy_Range").Copy Worksheets("Metrics").Range("Paste_Range")

I'm a bit new to the forum.. Where can I rate your help?

Thanks a lot once again!

Have a nice day!

Adam