Excel Help

[jnalpak]

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]

='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]

[ 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]

I think exceltips.com is out there...

THE Link