Possible to link 2 tables so that adding rows to 1 will add rows to the other?

[xdrenched]

I have a data entry table with about 1000 observation rows, and I have a hidden aggregate data table grabbing data from the data entry table that I want to use as the data source for pivot tables. Here's my problem: I want people to be able to add new rows in the data entry table if 1000 rows is not enough. They can hit Tab + Enter and that's fine. HOWEVER, I want my aggregate data table to also automatically get new rows when this happens, that still point to the data entered in the data entry table. Is this possible? Thanks!

[dflak]

If you are using "real" Excel tables, any formulas that reference them will reference the exact number of rows the table has. See this article: http://www.utteraccess.com/wiki/inde...ables_in_Excel.

[xdrenched]

Thank you! Good to know.