Help creating hyperlink to other worksheets from cell values

[mits]

I have a workbook with a summary worksheet and a seperate worksheet for every computer in the office.

The worksheet name is the serial number of the computer. Each computer worksheet is copied from a template so they are all the same.

I have a macro that copies certain bits of info from each worksheet and copies into columns on the summary worksheet.

One of the columns in the summary worksheet is the serial number. All the info in the summary worksheet are links to the seperate worksheet.(not values)

I would like to automatically create / convert the serial number cell to a hyperlink that opens the specific worksheet.
Any ideas?

Thanks in advance

 

[nbrcrunch]

1. click the search link on this site

2. In the search criteria box, enter: hyperlink

3. In the author box type: nbrcrunch


edited:
I finally figured out how to post the search syntax without needing to post the above...


http://www.mrexcel.com/board2/search.php?search_keywords="hyperlink"?search_author="nbrcrunch"

edited again. Oh well, just copy the text between the url markers and paste into your address line in your broswer

 

[Joe Was]

You can do it without hyperlinks.

Limit the Selection_Change Event for that Sheet to the column that has your ID#'s

If that workbook also has sheets named for every ID# then the Event will load the target cells value into:

Sheets(Target.Value).Select

And take you to that sheet when you click the cell with the ID#



Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'The lists Sheet Module, like: Sheet1.

If Target.Column <> 1 Then Exit Sub

If (Target.Value <> xlNull And Target.Column = 1) Then Sheets(Target.Value).Select
End Sub