Type data in A1:A10 of Sheet1


In Sheet2 in any cell (say in cell B1) copy the formula (F2copy paste the
formulaEnter)
=INDEX(Sheet1!$A$1:$A$10,ROW(A1))
and drag/copy down as required upto B10..

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


"ishah" wrote:

Thanks Jacob.
I need to know how to apply the formula. Does it go up in the 'formula' bar?
I tried that but could not figure out how to make it work.

The formula just appeared in the cell (A1) and did not perform the function
of bringing the data from sheet 1 over to sheet 2. I know I must be missing
something here. How do I set this up in the spreadsheet?
--
ishah


"Jacob Skaria" wrote:

If you are looking for a table with more than 1 column or row then try the
below and copy down and across as required.

=INDEX(table,ROW(A1),COLUMN(A1))

=INDEX($C$10:$I$11,ROW(A1),COLUMN(A1))

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


"Jacob Skaria" wrote:

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?