link two spreadsheets and copy cell ref accross row
 

I'm using Excel 03 and I'm linking multiple spreadsheets to one. So say I
have a row that has maybe 15 cells linked to 15 cells in another spreadsheet
(or workbook.) If I enter the equal sign = in the cell and then switch to the
other workbook and select the cell I want to link to and then I hit enter;
I'm able to link the cell the way I want to. However, after that's done, and
I try to drag the formatting to all of the other 14 cells, the cells are not
updated correctly. I get the same reference in each cell as the first one.
The only difference would be that the first cell would have an A in the cell
ref. the second cell would have a B in the ref., the third cell would have a
C, and so on.... But again, when I drag the cell to update the other cells -
all ref's have an A. How do I update the other cells so that I don't have to
manually change the A to a C and A to a B and the A to a C - God I hope this
makes sense - tough to word it... Appreciate your help.

link two spreadsheets and copy cell ref accross row
 

Remove the absolute references from your formula. I.e., where your formula
looks like this:
$A$2
remove the dollar signs and change to:
A2
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JK" wrote:

I'm using Excel 03 and I'm linking multiple spreadsheets to one. So say I
have a row that has maybe 15 cells linked to 15 cells in another spreadsheet
(or workbook.) If I enter the equal sign = in the cell and then switch to the
other workbook and select the cell I want to link to and then I hit enter;
I'm able to link the cell the way I want to. However, after that's done, and
I try to drag the formatting to all of the other 14 cells, the cells are not
updated correctly. I get the same reference in each cell as the first one.
The only difference would be that the first cell would have an A in the cell
ref. the second cell would have a B in the ref., the third cell would have a
C, and so on.... But again, when I drag the cell to update the other cells -
all ref's have an A. How do I update the other cells so that I don't have to
manually change the A to a C and A to a B and the A to a C - God I hope this
makes sense - tough to word it... Appreciate your help.

link two spreadsheets and copy cell ref accross row
 

I always forget that - thanks for your help.

"Luke M" wrote:

Remove the absolute references from your formula. I.e., where your formula
looks like this:
$A$2
remove the dollar signs and change to:
A2
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JK" wrote:

I'm using Excel 03 and I'm linking multiple spreadsheets to one. So say I
have a row that has maybe 15 cells linked to 15 cells in another spreadsheet
(or workbook.) If I enter the equal sign = in the cell and then switch to the
other workbook and select the cell I want to link to and then I hit enter;
I'm able to link the cell the way I want to. However, after that's done, and
I try to drag the formatting to all of the other 14 cells, the cells are not
updated correctly. I get the same reference in each cell as the first one.
The only difference would be that the first cell would have an A in the cell
ref. the second cell would have a B in the ref., the third cell would have a
C, and so on.... But again, when I drag the cell to update the other cells -
all ref's have an A. How do I update the other cells so that I don't have to
manually change the A to a C and A to a B and the A to a C - God I hope this
makes sense - tough to word it... Appreciate your help.