J
Jack Frost
I am having problems working out how to automatically place text from one
cell into a cell in another sheet.
I have read the post on 10 April 07 "Repeat text in exact cells in
multi-worksheets" and tried the solution:
"select the cell in question in the 2nd sheet, type an equal
sign, then click the 1st sheet tab and the cell where you want to link to,
then press enter. "
When I do this, I get the formula showing up in the cell to be copied to (in
my sheet the formula is: =People!B2
but the actual text in the cell to be copied doesn't appear.
I can't work out what is going on - can anyone help?
cell into a cell in another sheet.
I have read the post on 10 April 07 "Repeat text in exact cells in
multi-worksheets" and tried the solution:
"select the cell in question in the 2nd sheet, type an equal
sign, then click the 1st sheet tab and the cell where you want to link to,
then press enter. "
When I do this, I get the formula showing up in the cell to be copied to (in
my sheet the formula is: =People!B2
but the actual text in the cell to be copied doesn't appear.
I can't work out what is going on - can anyone help?