J
JK
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.
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.