Macro Assistance with a Drop Down Listy

[Skedwards323]

Hello - I would like to develop a "Jump to" macro button that jumps to the appropriate section of the worksheet to display the data. The corresponding data are listed in column A of the worksheet in different cells (ranging from cell A6 to cell A347). I have tried code from other forums but nothing seems to provide the "jump to" functionality I am looking for. Any suggestions?

 

[Candyman8019]

I typically name a jump point (for example, "jumphere") and then you can use a simple macro to go there.

Sub Macro1()
Application.Goto Reference:="jumphere"
End Sub

 

[Candyman8019]

then use this VBA to execute various macros depending on the value of the dropdown list (assuming the dropdown is in Cell A2):
Private Sub jumpcell(ByVal Target As Range)
If Not Intersect(Target, Range("A2")) Is Nothing Then
Select Case Range("A2")
Case "dropdown list value1": Macro 1
Case "dropdown list value2": Macro 2
End Select
End If
End Sub

 

[Candyman8019]

I made one error on the VBA above...the first line should read:
Private Sub Worksheet_Change(ByVal Target As Range)
so that it executes whenever the worksheet is updated.