Dropdown List linking to Specific Sheet

[jhhudson]

Hi all,

Currently looking to create athlete programmes and am looking to allow the athletes to select their name from a dropdown box. By clicking on their name, this then will take them to their individual tab/sheet to edit and input data from training sessions. This, theoretically, will save them searching for their tab/sheet as I will have 30+ tabs on the one document. Any advice on how to do this?

Thanks in advance.

 

[Fluff]

Hi & welcome to MrExcel.
How about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address(0, 0) = "[COLOR=#ff0000]E1[/COLOR]" Then
      Sheets(Target.Value).Activate
   End If
End Sub

This needs to go in the sheet module for the sheet that contains the dropdown.
You'll also need to change the value in red to match the cell that contains the dropdown