Prev: Two Condition Vlookup
Next: sort data
From: laliwalden on 7 Mar 2010 18:59
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!!
From: FSt1 on 7 Mar 2010 19:23
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!!
From: Don Guillett on 7 Mar 2010 19:32
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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"laliwalden" <laliwalden(a)discussions.microsoft.com> wrote in message
news:27890AC3-E0B2-4294-B8C8-BCF651203E95(a)microsoft.com...
>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!!

 | 
Pages: 1
Prev: Two Condition Vlookup
Next: sort data