+ Reply to Thread
Results 1 to 4 of 4

Using Dropdown to jump to specific cell

  1. 06-29-2018, 10:25 AM #1
    billio75
    billio75 is offline
    Registered User
    Join Date
    09-24-2014
    Location
    West Yorks
    MS-Off Ver
    Excel 2007
    Posts
    3

    Using Dropdown to jump to specific cell

    I've noticed there are a number of answers to similar questions already but I'm struggling to get them to work so apologies for a potentially duplicate question.

    I have a large spreadsheet with a wide range of training course data held in various sections. I would like to use a drop down list of the various course titles so that the user, when selecting a course title, is taken straight to the relevant section of the spreadsheet. The dropdown is currently located in AJ2 and sources from B51:B85 (including a blank at the top).

    As an example, if they select Health & Safety Awareness, I need to jump to AG7. If selecting 'Equality and Diversity', I need to jump to H95 and so on for the remaining course titles. If nothing is selected, then the sheet continues to allow navigation as normal.

    Any suggestions really welcome - thanks!
    Reply With QuoteRegister To Reply
  2. 06-29-2018, 10:37 AM #2
    CK76
    CK76 is offline
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: Using Dropdown to jump to specific cell

    Without sample workbook, hard to help you. To upload workbook, use "Go Advanced" button found at bottom right of Edit/Quick Reply screen.
    Then find "Manage Attachments" hyperlink and click on it. It will launch new tab/window.

    I'd imagine you could do this using .hyperlink.follow, using range.Find() or Application.Match() to find location to jump to.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein
    Reply With QuoteRegister To Reply
  3. 07-02-2018, 11:07 AM #3
    billio75
    billio75 is offline
    Registered User
    Join Date
    09-24-2014
    Location
    West Yorks
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Using Dropdown to jump to specific cell

    Hi,

    As requested - sample attached. You'll see the dropdown is already set up where I need it to be but other than that - any help welcome!

    Thanks,

    C.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-02-2018, 12:28 PM #4
    modytrane
    modytrane is offline
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Using Dropdown to jump to specific cell

    See attached file.
    Macro used:

    Please Login or Register  to view this content.
    Column G has list of cell addresses to jump to.
    Cell AO2 has formula to get the address from column G.
    HTML Code: 
    Hope this helps.
    Attached Files Attached Files
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] If answer Yes on a dropdown box, jump to a specific cell?
    By trenzalore888 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-26-2016, 02:50 PM
  2. how to jump into a specific cell
    By excelrio in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 08-07-2016, 10:18 PM
  3. [SOLVED] Macro to jump to a cell that matches the text selected from a dropdown list.
    By agalvan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2014, 06:28 PM
  4. Need macro to jump to specific cell determined by date.
    By mhelmers in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-13-2012, 06:19 PM
  5. jump to specific date in cell-range based on last opening of workbook
    By wamp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-20-2008, 09:06 AM
  6. Jump to Sheet Dropdown List
    By Mike in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  7. Dropdown with a "jump to" cell name. Like a Go button..
    By thom hoyle in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2005, 04:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1