Need Help!!

  • Thread starter Thread starter laliwalden
  • Start date Start date
L

laliwalden

I am trying to, I guess, Link worksheets? (I am an Access user, I do not know
Excel very well) So please excuse me!!

Anyway, I have a master sheet with a list of employees names. Then each
employee has their own sheet, to track training. I want to be able to click
on their name on the master sheet and it take me to their individual sheet.

How in the world do I do this!!???

Thanks so much!!
 
hi
you want a hyperlink
righ click the employees name. from the popup, select hyperlink(at the bottom)
with th hyperlink dialog comes up, to the far left select "place in this
document".
select the employees sheet.
click ok

Regards
FSt1
 
Right click sheet tab>view code>insert this. Now, double click on a name to
goto that sheet.Assumes the name and the sheet name are the SAME.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Application.DisplayAlerts = False
Dim WantedSheet As String
WantedSheet = Trim(ActiveCell.Value)
If WantedSheet = "" Then Exit Sub
On Error Resume Next
If Sheets(WantedSheet) Is Nothing Then
' GetWorkbook ' calls another macro to do that
Else
Application.GoTo Sheets(WantedSheet).Range("a4")
End If
Application.DisplayAlerts = True
End Sub
 
Back
Top