Help creating hyperlink to other worksheets from cell values

mits

New Member
Joined
May 2, 2003
Messages
16
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
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,680
Messages
5,573,624
Members
412,539
Latest member
itchy00
Top