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

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

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

Please Login or Register  to view this content.