PDA

View Full Version : Excel Help


jnalpak
09-21-2005, 09:11 PM
I seem to have forgotten a simple task and need some help.

I have a few worksheets currently named "heart" "spade" and "trout"

I want to take the totals of some models and run the results on the "heart" page....

whats the formula to refer to worksheet B - E34 and show it on worksheet a - B23

also, any decent "office help" sites on the net?

Nomad84
09-22-2005, 12:26 AM
='worksheetname'!E34 seems to do it. I just began entering a formula (typed an equals sign), clicked the appropriate worksheet tab, and clicked the needed cell. Excel then entered the correct syntax just as it would if I had clicked a cell in the same worksheet.

Hope this helps.

jnalpak
09-22-2005, 10:05 AM
[ QUOTE ]
='worksheetname'!E34 seems to do it. I just began entering a formula (typed an equals sign), clicked the appropriate worksheet tab, and clicked the needed cell. Excel then entered the correct syntax just as it would if I had clicked a cell in the same worksheet.

Hope this helps.

[/ QUOTE ]

thanks much

Schwartzy61
09-22-2005, 02:01 PM
I think exceltips.com is out there...

THE Link (http://exceltips.vitalnews.com/)