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

bgiovanni1! · Dec 11, 2019

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:

Thanks in advance for any help!

p45cal · Dec 12, 2019

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.

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

bgiovanni1!

New member

p45cal

Super Moderator

Attachments