Query from one table to the other in same workbook

[craig80]

Hello,

I am currently working with a large data set of names, dates, rates, positions and effectivness. My data is in table format, and ranges circa 100 by 200 in size.

I would like to have, within the same workbook, a connection to a second table, one which will update with any added rows from table 1, then autopopulate the formula down, in table 2?

I have tried to use the connection tabs, but I am not having much luck.

If anyone could point me to any guides, or help with some direction. I would be very grateful.

Thanks
Craig