Hyperlink to cell within the same Workbook

[Carlos Pinto]

I Have a workbook with about 30 sheets, I named cells
contained essential information. With so many sheets I
decided to make another one and I call it Summary. In
this sheet I created a search with 3 droplists that are
linked to functions.

Know I need make a link to the cell that contains the
result of my search, so I can see the items that have
contributed for the result.
I have tried the funtion "Hyperlink" but it only works
with files or url and I can't make it work within the
workbook.

How can I make a hyperlink within an workbook? Make an
hyperlink to a cell in another sheet but in the same
workbook?

 

[Arvi Laanemets]

Hi

Enter the text, you want to have displayed in cell with hyperlink
Activate the cell. Insert.Hyperlink and press 'Bookmark' control
Select sheet, you want to link to, and enter cell reference. OK
OK


Arvi Laanemets

 

[Stephen Dunn]

Hi Carlos,

URL's are the default setting of hyperlinks, but if you check the side bar
of the hyperlink dialog box, you should see options for other link types,
including "Place in this document".

HTH
Steve D.

 

[Dave Peterson]

How about something like this:

=HYPERLINK("#"&CELL("address",'sheet2'!A4),"test2")

(the single quotes around the sheet name may not be required, but they don't
hurt.)

David McRitchie is in the process of updating his BuildTOC (build table of
contents) (or so he's written <bg>) to use a formula like this.

He has a macro that builds a table of contents using a different formula. You
may want to try it out.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm