G
Guest
EXCEL 2003 When trying 2 link 2 pages from different workbooks I can only get
cell A1 to come to the destination workbook. Help. Ema
cell A1 to come to the destination workbook. Help. Ema
G
Guest
what is the procedure you are using to link?
G
Guest
open both wkbooks, save destination book, have other sheet of wkbook open,
enter equal sign in ?address line of destination bk and click on top left
corner of source sheet. I get a formula but only the A1 cell comes over ????
enter equal sign in ?address line of destination bk and click on top left
corner of source sheet. I get a formula but only the A1 cell comes over ????
D
David Biddulph
If you are trying to pull information from one cell of the source sheet to
one cell of the destination sheet, then that's what you've got. It should
look something like:
='[Sourcebookname.xls]Source sheet name'!A1. If it includes $ signs for
absolute addressing, such as $A$1, then you probably want to remove those if
you want to copy the formula to other cells as below.
Having ensured that you've got relative rather than absolute addressing,
then if you wish to do something equivalent for other cells on the sheet,
then merely copy your destination cell across as many rows and column as
applicable.
If you are trying to pull information from a range on the source sheet to a
cell in the destination sheet, then when you've instered an appropriate
formula in the destination sheet you can select the relevant range from the
source sheet, such as:
=AVERAGE('[Sourcebookname.xls]Source sheet name'!$A$1:$D$8)
one cell of the destination sheet, then that's what you've got. It should
look something like:
='[Sourcebookname.xls]Source sheet name'!A1. If it includes $ signs for
absolute addressing, such as $A$1, then you probably want to remove those if
you want to copy the formula to other cells as below.
Having ensured that you've got relative rather than absolute addressing,
then if you wish to do something equivalent for other cells on the sheet,
then merely copy your destination cell across as many rows and column as
applicable.
If you are trying to pull information from a range on the source sheet to a
cell in the destination sheet, then when you've instered an appropriate
formula in the destination sheet you can select the relevant range from the
source sheet, such as:
=AVERAGE('[Sourcebookname.xls]Source sheet name'!$A$1:$D$8)
G
Gord Dibben
Try an alternate method to link all cells you want.
Select a range of cells in book1......say A1
20
Copy then switch to book2 and select a cell.
Edit>Paste Special>Paste Link>OK>Esc
Gord Dibben MS Excel MVP
Select a range of cells in book1......say A1
20Copy then switch to book2 and select a cell.
Edit>Paste Special>Paste Link>OK>Esc
Gord Dibben MS Excel MVP
G
Guest
David, I checked the formula, It didn't have the parentheses, I added them. I
still cannot get the whole range. Only A1 is coming over. I have tried this
now on 3 different computers. I must be doing something wrong.
I am saving the destination (blank) workbook sheet. putting the equal sign
in the address line (which puts it in the a1 cell) then going to other
workbook and sheet, I've tried highlighting the entire range, typing the
entire range, clicking on the top left corner of the page, the formula in the
destination page looks OK. Any other ideas?
still cannot get the whole range. Only A1 is coming over. I have tried this
now on 3 different computers. I must be doing something wrong.
I am saving the destination (blank) workbook sheet. putting the equal sign
in the address line (which puts it in the a1 cell) then going to other
workbook and sheet, I've tried highlighting the entire range, typing the
entire range, clicking on the top left corner of the page, the formula in the
destination page looks OK. Any other ideas?
G
Guest
copy the A1 cell in the destination sheet and paste it wherever you want
information to show.
the procedure you used will only activate the A! cell
information to show.
the procedure you used will only activate the A! cell