Hatrack River Forum: Excel 2002 question

This is topic Excel 2002 question in forum Books, Films, Food and Culture at Hatrack River Forum.

To visit this topic, use this URL:
http://www.hatrack.com/ubb/main/ultimatebb.php?ubb=get_topic;f=2;t=046378

Posted by Boon (Member # 4646) on :

I think I've seen this done elsewhere, but for the life of me I canm't figure out how to do it.

What I'd like is for whatever value is in C94 on the second sheet to also show up in C4 on the first sheet. The C94 on the second sheet currently has a formula to average the column, and I'd like that average to show up on the first page and change when numbers are changed on the second sheet.

I hope someone here can help me. I've been searching for the answer for hours, and can't find it.

Posted by Mr.Funny (Member # 4467) on :

Basically, you set the equation bar on C4 to, if, say, the second sheet was named "Cheese",

code:
=Cheese!C94

Hope that helps!

Posted by Boon (Member # 4646) on :

Didn't work. Instead of showing what's in Sheet2 C94, it's showing =Sheet2!C94 as a blue underlined link that doesn't go anywhere. Grrr.

Posted by Heffaji (Member # 3669) on :

One way this can be done is by:

1.Enter your equation on the 2nd sheet.
2.Go to the first sheet and select your cell
3.Type "=" and then click onto the 2nd sheet and select the cell.
4.Hit return, and you should have it.

Posted by Boon (Member # 4646) on :

That put the exact same thing in C4. [Frown]

Is my Excel broken?

Posted by Heffaji (Member # 3669) on :

That is odd. Both Mr. Funny's suggestion and my own should work. Sorry I can't be of more help.

Posted by Boon (Member # 4646) on :

[Frown]

Thanks for trying, though. Both of you.

Posted by accio (Member # 3040) on :

Your second sheet is showing the formulas. Try

Press CTRL + ` (grave accent).

Posted by Boon (Member # 4646) on :

accio, I think I love you.

That was exactly it...now what did it do? Why did that work?

Posted by accio (Member # 3040) on :

I’m glad it worked!! Somehow you turned on the “Formula Auditing Mode”. You can turn it on/off by using the short cut I gave you. The “Formula Auditing” resides in Tools drop down menu.