Hyperlik to Another sheet

[Ted Dennis]

I have the following code which on the selection of yes in the dropdown in cell J67 the sheet named DIP is activated and takes the user there. Under cell J67 there are 5 other cells J67 to J70 which all could have a yes selected. Only 1 yes will be selected within the range, Dependent on which cell is selected would then change what sheet the user is taken too. How do I loop the existing code ?

Thanks
Ted

[Ted Dennis]

Having trouble with Sucuri so having to post piecemeal

[Ted Dennis]

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Target.Address = "$J$67" Then Exit Sub ' check to see if the value being changed is in your drop down cell
If Target.Value = "yes" Then
Sheets("DIP").Select
Sheets("DIP").Range("B2").Select ' Sheet to select and cell if the drop down is moved to "yes"
End If
End Sub

[Ted Dennis]

Cannot post with CODE tags sorry

[Ted Dennis]

ive sorted it now

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("$J$67") = "yes" Then
Sheets("DIP").Select
Sheets("DIP").Range("B2").Select

ElseIf Range("$J$68") = "yes" Then
Sheets("1st Time Buyer").Select
Sheets("1st Time Buyer").Range("B2").Select

ElseIf Range("$J$69") = "yes" Then
Sheets("Home Mover").Select
Sheets("Home Mover").Range("B2").Select

ElseIf Range("$J$70") = "yes" Then
Sheets("Further Advance").Select
Sheets("Further Advance").Range("B2").Select

ElseIf Range("$J$71") = "yes" Then
Sheets("BTL-CBTL").Select
Sheets("BTL-CBTL").Range("B2").Select

ElseIf Range("$J$72") = "yes" Then
Sheets("Holiday Home").Select
Sheets("Holiday Home").Range("B2").Select

ElseIf Range("$J$73") = "yes" Then
Sheets("Mtge Free Capital Raising").Select
Sheets("Mtge Free Capital Raising").Range("B2").Select

ElseIf Range("$J$74") = "yes" Then
Sheets("Help to Buy").Select
Sheets("Help to Buy").Range("B2").Select
End If

End Sub