hyperlink to worksheet

[CharlesEric]

Hey guys,

Any idea on how to create a Hyperlink to a specific worksheet in a workbook instead of just the workbook?

[Palmetto]

The Excel Help is pretty clear on how to do this.

In the worksheet/workbook to which you want to link, pick a cell and give it a name. The use this name in the hyperlink functions as shown in the workbook that is to contain the link.

=HYPERLINK("[C:\My Documents\Mybook.xls]Totals")

In this example, "Totals" is a named cell in the file "Mybook.xls".

[CharlesEric]

Ha. That is a great solution! Unfortunately, I'm using a file management program called CIDM to classify my files and the hyperlinks are linked to files INSIDE CIDM, and not on the computer. This is what the file name looks like :

NCR-#2360807-BINDER 2009-2010 - ORGANIZATION ACTIVITIES/EXPENDITURES - EDUCATION AND SOCIAL PROGRAMS

And this is what I tried based on your quote:

=HYPERLINK(''[NCR-#2394413-BINDER 2009-2010 - ORGANIZATION APPLICATION REQUIREMENTS - EDUCATION AND SOCIAL PROGRAMS]SkillsLink'')

Unfortunately, it says that there is an error. Maybe because the link is not in the computer but in the file management system. Maybe my question is then more concerning CIDM than Excel.

But thanks a lot anyways. It'll help me in the future I'm sure.