Creating a Drop down list that will take you to a specific place on a worksheet.

**frankday** · 10-13-2018, 04:21 PM

I have a very long worksheet in excel. I want to put a dropdown at the top of the sheet that will take me to a specific spot in the worksheet. For example if I have Office Supply, Power, and Phone in a drop down list. When I select Power I want it to take me to the section of the sheet that deals with power.

Can anyone help?

**Logit** · 10-13-2018, 04:52 PM

.
Hyperlinks

**frankday** · 10-13-2018, 10:55 PM

How do I use a hyperlink in a Data validation drop down?

**FoxSeaLady** · 10-13-2018, 05:00 PM

Hi

The easy solution is to filter the spreadsheet.

Click in the arrow in the frame at A1. Select Ribbon Data/Filter.

By selecting the resulting arrow in approriate column you can filter needed ie power.

Hope this helps and don't forget the reputation points if appropriate.

Cheers

**frankday** · 10-13-2018, 10:57 PM

I am looking for something more like a one click. But I don't have enough room for that many buttons.

**FDibbins** · 10-14-2018, 12:07 AM

I dont think you can do the HL inside the DD. If you would be OK with using a helper cell for the HL (say A1), you could the DD in, say B1
A1=HYPERLINK("#"&"A"&MATCH(B1,A:A,0),B1)

**alansidman** · 10-14-2018, 12:58 AM

Drop down boxes do not work with Worksheet_ChangeEvent Macros, however, if you abandon the DD and type specific words into the cell, then you can activate the move with a Worksheet_ChangeEvent.

**Logit** · 10-14-2018, 11:47 AM

.
This is just one of many websites that provide instructions to utilize Data Validation Dropdown with hyperlinks :

https://www.excel-bytes.com/how-to-u...tion-in-excel/

Search for VBA Data Validation Drop Down Hyperlinks

Creating a Drop down list that will take you to a specific place on a worksheet.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Creating a Drop down list that will take you to a specific place on a worksheet.

Re: Creating a Drop down list that will take you to a specific place on a worksheet.

Re: Creating a Drop down list that will take you to a specific place on a worksheet.

Re: Creating a Drop down list that will take you to a specific place on a worksheet.

Re: Creating a Drop down list that will take you to a specific place on a worksheet.

Re: Creating a Drop down list that will take you to a specific place on a worksheet.

Re: Creating a Drop down list that will take you to a specific place on a worksheet.

Re: Creating a Drop down list that will take you to a specific place on a worksheet.

Thread Information

Users Browsing this Thread

Similar Threads

I want specific text to appear (a list) if specific items are picked in a drop down list.

[SOLVED] VBA to Take List of names and place on specific sheets.... Hard!!!

[SOLVED] Place text in a specific cell based on two separate drop down list entries

[SOLVED] Formula to place a list of names under a specific category

Choosing a worksheet with drop down list then selecting data with another drop down list

Macro for linking cells from different rows to a specific place on other worksheet

Assigning information to a specific place based on drop down box selection

Bookmarks

Bookmarks

Posting Permissions