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?

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?

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?

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?

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?

If the sheet is composed of the table you desire, on yoru other spreadsheet,
go to Data Import External Data Import Data

Change your files of type to Excel

Select your source file and spreadsheet and import it.

Once done, you can set the data to update on open or refresh whenever needed
by going back to Data

"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?

I was not able to find 'Import External Data Import Data. I am working with
office 2007 and I think you might be talking in 2003 version.

IF, I could find a way to do it as you describe below in office 2007, would
this also capture all the formatting? I have figured out how to make every
cell change when edited, but it does not adapt the original sheet's
formatting which is critical in this project. I have various headings in
larger print and bolded as well as some cells that have a hierachy (by
indenting within the same cell. i.e. xxxxxx

xxxxx

Is there any way to capture all this formatting as well as just the data?
--
ishah


"Sean Timmons" wrote:

If the sheet is composed of the table you desire, on yoru other spreadsheet,
go to Data Import External Data Import Data

Change your files of type to Excel

Select your source file and spreadsheet and import it.

Once done, you can set the data to update on open or refresh whenever needed
by going back to Data

"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?

Some hints on 2003 to 2007 command mapping:
a.. http://office.microsoft.com/en-us/ex...491511033.aspx
b.. http://www.rondebruin.nl/0307commands.htm
c..
http://www.computerworld.com/action/...leId=9028 218

--
David Biddulph

"ishah" wrote in message
...
I was not able to find 'Import External Data Import Data. I am working
with
office 2007 and I think you might be talking in 2003 version.
....

2007 DataFrom Web

But formatting will not be captured, I'm sorry to say.


Gord

On Thu, 29 Oct 2009 07:37:02 -0700, ishah
wrote:

I was not able to find 'Import External Data Import Data. I am working with
office 2007 and I think you might be talking in 2003 version.

IF, I could find a way to do it as you describe below in office 2007, would
this also capture all the formatting? I have figured out how to make every
cell change when edited, but it does not adapt the original sheet's
formatting which is critical in this project. I have various headings in
larger print and bolded as well as some cells that have a hierachy (by
indenting within the same cell. i.e. xxxxxx

xxxxx

Is there any way to capture all this formatting as well as just the data?