+ Reply to Thread
Results 1 to 8 of 8

Drop down list hyperlinking to the data values

  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

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Drop down list hyperlinking to the data values

    This will require VBA (there was a similar thread yesterday where the OP asked for more or less the same thing, but I can't find it for now). I'll move this thread to the VBA section.

    EDIT: Have a look here at that similar request I mentioned: https://www.excelforum.com/excel-for...he-answer.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Drop down list hyperlinking to the data values

    In the same drop down cell it can not possible to make hyperlink.

    You must create some helper cell.

    try in sheet dd_list

    C3=B3
    B4
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    B4 would be your hyperlink.

    Check the attached file.

    Hope it will help you.
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

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

    Re: Drop down list hyperlinking to the data values

    Quote Originally Posted by AliGW View Post
    This will require VBA (there was a similar thread yesterday where the OP asked for more or less the same thing, but I can't find it for now). I'll move this thread to the VBA section.

    EDIT: Have a look here at that similar request I mentioned: https://www.excelforum.com/excel-for...he-answer.html
    Thank you very much. Sad that it can be done only with VBA. I'll wait than until I get to learning the VBA part. )

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

    Re: Drop down list hyperlinking to the data values

    Quote Originally Posted by shukla.ankur281190 View Post
    In the same drop down cell it can not possible to make hyperlink.

    C3=B3
    B4
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    B4 would be your hyperlink.

    Thank you very much. It is a very nice way around VBA, though it requires a bit more cells. Thank you.

  6. #6
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Drop down list hyperlinking to the data values

    Quote Originally Posted by Vitalite View Post
    Thank you very much. It is a very nice way around VBA, though it requires a bit more cells. Thank you.
    Can you please upload your excel workbook expected result???

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

    Re: Drop down list hyperlinking to the data values

    Quote Originally Posted by shukla.ankur281190 View Post
    Can you please upload your excel workbook expected result???
    Well, it's basically the same I showed. I have added a bit more description. I will think of how to use your approach - maybe, I will hide the initial column, leaving visible only the one that creates links, to avoid having duplicate columns. Thank you for your help and interesting solution.
    Attached Files Attached Files

  8. #8
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Drop down list hyperlinking to the data values

    Well you can add some text like "Click here for information about task no :- " with Hyperlink to inform user how to get on the same cell for reading information.

    Check the attached file.
    Attached Files Attached Files

+ Reply to Thread

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