Results 1 to 2 of 2

Thread: Excel:data validation drop-down list- Populate the matching hyperlink from another co

  1. #1
    Neophyte bgiovanni1!'s Avatar
    Join Date
    Dec 2019
    Posts
    1
    Articles
    0
    Excel Version
    365

    Excel:data validation drop-down list- Populate the matching hyperlink from another co



    Register for a FREE account, and/
    or Log in to avoid these ads!

    So, I wish Excel or Google Sheets had the option of keeping links intact when you did a drop down list in data validation, but it doesn't. I decided the next best thing would be to have another column inserted next to the column with the drop down list, and get a formula that would auto-populate the column with the matching hyperlink if that item was picked from the drop-down. This is the spreadsheet I am working with:
    Name:  Picture for excel.png
Views: 80
Size:  92.7 KB


    Thanks in advance for any help!


  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,649
    Articles
    0
    Excel Version
    365
    Consider using a small macro. In the attached, make choices in the green shaded area. To view the code, right-click on the sheet's tab and choose View Code.
    The single line which does the business is:
    Code:
    Me.Hyperlinks.Add Anchor:=Target, Address:=Target.Value
    Consider attching an Excel workbook rather than a picture of one.
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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