FacebookTwitter
Hatrack River Forum   
my profile login | search | faq | forum home

  next oldest topic   next newest topic
» Hatrack River Forum » Active Forums » Books, Films, Food and Culture » Excel 2002 question

   
Author Topic: Excel 2002 question
Boon
unregistered


 - posted            Edit/Delete Post 
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.

IP: Logged | Report this post to a Moderator
Mr.Funny
Member
Member # 4467

 - posted      Profile for Mr.Funny           Edit/Delete Post 
Basically, you set the equation bar on C4 to, if, say, the second sheet was named "Cheese",
code:
=Cheese!C94

Hope that helps!
Posts: 1466 | Registered: Jan 2003  |  IP: Logged | Report this post to a Moderator
Boon
unregistered


 - posted            Edit/Delete Post 
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.
IP: Logged | Report this post to a Moderator
Heffaji
Member
Member # 3669

 - posted      Profile for Heffaji   Email Heffaji         Edit/Delete Post 
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.

Posts: 291 | Registered: Jun 2002  |  IP: Logged | Report this post to a Moderator
Boon
unregistered


 - posted            Edit/Delete Post 
That put the exact same thing in C4. [Frown] Is my Excel broken?
IP: Logged | Report this post to a Moderator
Heffaji
Member
Member # 3669

 - posted      Profile for Heffaji   Email Heffaji         Edit/Delete Post 
That is odd. Both Mr. Funny's suggestion and my own should work. Sorry I can't be of more help.
Posts: 291 | Registered: Jun 2002  |  IP: Logged | Report this post to a Moderator
Boon
unregistered


 - posted            Edit/Delete Post 
[Frown] Thanks for trying, though. Both of you.
IP: Logged | Report this post to a Moderator
accio
Member
Member # 3040

 - posted      Profile for accio   Email accio         Edit/Delete Post 
Your second sheet is showing the formulas. Try

Press CTRL + ` (grave accent).

Posts: 333 | Registered: Feb 2002  |  IP: Logged | Report this post to a Moderator
Boon
unregistered


 - posted            Edit/Delete Post 
accio, I think I love you.

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

IP: Logged | Report this post to a Moderator
accio
Member
Member # 3040

 - posted      Profile for accio   Email accio         Edit/Delete Post 
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.
Posts: 333 | Registered: Feb 2002  |  IP: Logged | Report this post to a Moderator
   

   Close Topic   Feature Topic   Move Topic   Delete Topic next oldest topic   next newest topic
 - Printer-friendly view of this topic
Hop To:


Contact Us | Hatrack River Home Page

Copyright © 2008 Hatrack River Enterprises Inc. All rights reserved.
Reproduction in whole or in part without permission is prohibited.


Powered by Infopop Corporation
UBB.classic™ 6.7.2