How to link 2 excel tables?

[Vtikhon]

Hi,

I am using the Microsoft excel 2007.

The spreadsheet that I have contains 2 tables. The first table contains the data and the second table pulls data from the first table and also have some additional formulas.

How can I link those 2 tables, so that if I add a record to the first table, the second table would pick up that record as well?

Thanks