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,

Related:

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
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses