Previous Topic Next Topic

Excel refernce to another worksheet

Closed
Kit - 15 Oct 2010 à 12:04
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 15 Oct 2010 à 12:20
Hello,

When I try to reference a cell in another sheet of the same workbook, I get the formula instead of the value. i.e. +"sheet 2"!G65 displays "+"sheet 2"!G65" instead of the value in G65.

I have never experienced this problem before.

Thank you,

1 response

Réponse 1 / 1
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 183
15 Oct 2010 à 12:20
where you have the + in the formula put a =
this will tell the cell that it equals the contents of the cell in the other sheet.

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Automatically transfer data from one sheet to another
sunny49er -
TrowaD -

22 responses
Copy worksheet from one workbook to another workbook in MS Office Excel
SrinivasNittala -
ac3mark -

1 response