Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I click on a drop down list and go to that data
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Right-click Drop down list | Excel Discussion (Misc queries) | |||
How do i set up a drop down list and hide my list data. | Excel Worksheet Functions | |||
I can't get a drop down list when a do a right click on a cell | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel |