how do I click on a drop down list and go to that data
Presumably each of the locations is a named range?
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Me.Range("A1") Then
Application.Goto Reference:=Target.Value, Scroll:=True
End If
End Sub
Assumes the dropdown list is in A1........adjust to suit.
This is sheet event code. Right-click on the sheet and "View Code"
Copy/paste the code into that module.
Alt + q to return to the Excel window.
Gord Dibben MS Excel MVP
On Mon, 2 Feb 2009 12:00:03 -0800, Donna
wrote:
I have created a drop down list for all of our locations. Within the same
spreadsheet is the data related to each location. How can I select the name
from the drop down list and go directly to that data within the spreadsheet
|