Results 1 to 8 of 8

Drop down list hyperlinking to the data values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-20-2017
    Location
    Boston, US
    MS-Off Ver
    Mac 2011
    Posts
    139

    Drop down list hyperlinking to the data values

    Hello!

    I will be grateful for your help on how to create, if possible, a drop down list (all values in list refer to a specific sheet in the same workbook) in such way that, when value is chosen, I can click on the cell and it will lead me to the exact cell with the same value on another sheet of the same workbook.

    If my drop down list is in Cell B3 on the sheet dd_list, and if I choose 2, then I would like upon making that choice being able to click on B3 and get to B4 on another sheet called list.

    I am attaching a workbook in case it can be easier to see.

    Thank you very much!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hyperlinking via/from Data Validation List? Only simple solution needed!
    By BrianLabigaliniKCC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2014, 11:29 AM
  2. Replies: 0
    Last Post: 06-16-2014, 10:44 AM
  3. Replies: 6
    Last Post: 11-01-2013, 06:25 PM
  4. Data Validation Drop Down Boxes (List) - Values Keep Duplicating
    By CJoQ in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2012, 05:07 AM
  5. Replies: 6
    Last Post: 06-07-2012, 02:28 PM
  6. Replies: 4
    Last Post: 06-07-2012, 10:04 AM
  7. Drop-Down Colours-elect from a list of data values
    By Bal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1