Previous Topic Next Topic

Excel refernce to another worksheet

Closed
Kit - Oct 15, 2010 at 12:04 PM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Oct 15, 2010 at 12:20 PM
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

Answer 1 / 1
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Oct 15, 2010 at 12:20 PM
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.
0

Similar discussions

How to specify macro for current active sheet
seo5906 -
Dave -

18 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses