Connect two tables

[rokandil]

Hi
I am curerntly trying to connect two tables, if to the first table one column will be added the second table will automatically grow to the same size and automatically transfer the formulas from the previous columns in table two to the newly created column.

Would be happy if you have a solution for me!

 

[sandy666]

automatically transfer the formulas from the previous columns in table two to the newly created column.

you want "transfer" formulas or data?

you can try PowerQuery which give you live copy of your first table with all data in the second table