Need Help!!
 

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!!

Need Help!!
 

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

"laliwalden" wrote:

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!!

Need Help!!
 

Right click sheet tabview codeinsert 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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"laliwalden" wrote in message
...
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!!