Try this in sheet2 and copy down as required which will link Sheet1 cells
A1:A10

=INDEX(Sheet1!$A$1:$A$10,ROW(A1))

to copy across
=INDEX(Sheet1!$A$1:$A$10,COLUMN(A1))

Now try with a different workbook

If this post helps click Yes
---------------
Jacob Skaria


"Linda" wrote:

I need to link to a table in a separate worksheet (and later on, into a
separate workbook).

Can a table be linked so that every cell in that table is updated when the
original table is updated?