Linking Tables Dynamically

[mgris]

Hey folks,


Is it possible to dynamically link a table to the content of another table?


Here is what I have done:


-Insert a table in A1:A3

-Insert a second table in C1:C3


If do this: E2=Table1[Column1]


Then it copies in e table 2 the content of the table 1


That's already a really cool feature...


But here is my problem:


If I type something in A5, excel automatically add one more row to table 1

I would like to link table 2 to table 1 so that whenever I add an item in table 1, table 2 automatically expands as well...


This would really AWESOME, and would avoid me many future kicks in the ass from my boss since data won't be missing anymore in my sheets


Please save my ass ! LOL


M.

 

[fred]

I got lost when I come to "Then it copies in e table 2 the content of the table 1".


that said, when you are entering data in table 1 it will of course expands automatically. But how can we expect table 2 to expand without data in it??


May be I have mistaken your question?

 

[Luke M]

Not sure about using tables, but maybe a psuedoformula would be like:

=IF(ROWS(A$2:A2)>Rows(Table1[Column1]),"",Table1[Column1])

and copy down as far as seems appropriate.


Idea of the formula is, if I have more formulas than I have records in table 1, show "", else show the record from table 1.