Create a drop down list that when name is selected it links to that persons tab

[Jamidd1]

Hello,

I was wondering if it was possible to create a drop down list that when a persons name is selected this takes them to tab with there data.

I look forward to hear from people!
Thanks
Jamidd

[Kevin#]

see attached workbook
When value in A6 or A2 change, employee sheet selected.


Names put in sheet ListofNames - with sheet name
Named range "NameList" created
2 options for you
- If sheet name = selected employee names then use first bit of code below - applies to selection from A2
- If sheet name differs to employee names, then use the 2nd bit of code - applies to selection from A6 (= sheets A to D)

this code sits at sheet level

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
        If Not Intersect(Target, Range("A2")) Is Nothing Then
            Sheets(Range("A2").Value).Select
        Else
        End If

If Target.Cells.Count > 1 Then Exit Sub
        If Not Intersect(Target, Range("A6")) Is Nothing Then
            Dim sName As String
            Name = Application.WorksheetFunction.VLookup(Range("A6"), Sheets("ListOfNames").Range("NameList"), 2, 0)
            Sheets(sName).Select
        Else
        End If

End Sub