posted
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 |
posted
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 |
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 |
Boon
unregistered
posted
That put the exact same thing in C4. Is my Excel broken?
IP: Logged |
posted
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 |
Boon
unregistered
posted
Thanks for trying, though. Both of you.
IP: Logged |
posted
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 |