linking worksheets
 

I was given a workbook that contains 10 worksheets. The first sheet is called
"index". On this sheet are links to each of the worksheets in the workbook.
All the other sheets contain the link "back to main index". Which takes the
user back to the index worksheet. Can anyone direct me to the help for this,
so I can learn how this is done? Is this something done manually? Or is it a
function or macro?
Thanks
Rob

linking worksheets
 

=HYPERLINK(linklocation,friendlyname)

where linklocation is the filepath (or object in Excel) and friendly name is
the name you use.

If you know HTML it's somewhat similar to <a href="http://www.cnn.com"Click
here for CNN</a where "Click here for CNN" would appear as text on screen,
and the link would take you to cnn.com.

HTH,

Dave
--
Brevity is the soul of wit.


"RobC" wrote:

I was given a workbook that contains 10 worksheets. The first sheet is called
"index". On this sheet are links to each of the worksheets in the workbook.
All the other sheets contain the link "back to main index". Which takes the
user back to the index worksheet. Can anyone direct me to the help for this,
so I can learn how this is done? Is this something done manually? Or is it a
function or macro?
Thanks
Rob