Dynamic linked table

[b0unce]

Hello,

I want to make a table in Sheet1 and make a direct link of that table in Sheet2. Any changes in Sheet1 should reflect in Sheet2. Even if I add additional columns or rows, everything should change the same way in Sheet2. Simply putting "=A1" etc. does not work as it only reflects to value changes, but does not reflect the structure changes of Sheet1. I am doing this to create a general form to make sales PLANS and FACTS which can be later filled in by our employees.

Has anyone ideas how that could be implemented?
Thank you!

 

[Rijnsent]

Hi b0unce,
you'll probably end up with VBA, writing a code that acts on changes in Table1/sheet1 and do the same in Table2/Sheet2. Having said that, there are plenty tough situations you'd have to catch in your code (e.g. inserting a column or row in the middle of your table). The way simpler alternative: first set up your main table1 and only when it's kind of finished copy it to table2/sheet2.
Hope those pointers help a bit,
Koen