Is it possible to link a whole table into another worksheet

[Linda]

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?

 

[Jacob Skaria]

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]

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

 

[Sean Timmons]

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

 

[ishah]

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?

 

[Jacob Skaria]

Type data in A1:A10 of Sheet1


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

If this post helps click Yes

 

[ishah]

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?

 

[David Biddulph]

Some hints on 2003 to 2007 command mapping:
a.. http://office.microsoft.com/en-us/excel/HA101491511033.aspx
b.. http://www.rondebruin.nl/0307commands.htm
c..
http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9028218

--
David Biddulph

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.

....

 

[Gord Dibben]

2007 Data>From Web

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


Gord