Need Help!!


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

Advertisements

F

FSt1

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
 
Ad

Advertisements

D

Don Guillett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top