+ Reply to Thread
Results 1 to 6 of 6

Add Hyperlink According to the List

  1. #1
    Registered User
    Join Date
    02-07-2013
    Location
    Istanbul
    MS-Off Ver
    Microsoft 365
    Posts
    19

    Add Hyperlink According to the List

    I think my question has been answered somewhere in forum, but I had no luck in my search results.
    I have a folder list in column G and name list in column H. What I want is make each of the cells in column H hyperlinked with the relative folder locations from column G. That is, when I put my excel file in the same folder as the parent folder of column H folders, I want to be able to open Folder-1 when I click Name-1.

    Note: By the way formula/function solution i.e.
    Please Login or Register  to view this content.
    won't do. I need a macro that inserts hyperlink without changing the text of column H.

    I tried to explain my case in following screenshot
    Hyperlink.png

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Add Hyperlink According to the List

    Try to put (into H20)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I am not sure that You don't have to put full path, not just ParentFolder (like ex. "Z:\Parents\ParentFolder")
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    02-07-2013
    Location
    Istanbul
    MS-Off Ver
    Microsoft 365
    Posts
    19

    Re: Add Hyperlink According to the List

    Quote Originally Posted by KOKOSEK View Post
    Try to put (into H20)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I am not sure that You don't have to put full path, not just ParentFolder (like ex. "Z:\Parents\ParentFolder")
    This will simply not do because;
    1. H20 will be seen as "Fodler-1"
    2. H20 will have a formula not hyperlinked text. (I want H20 text not to be changed)
    Last edited by poohly; 02-01-2019 at 12:16 PM.

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Add Hyperlink According to the List

    So, do you want to keep Name-X as hyperlinks for each of Folder-X, right?

    Please Login or Register  to view this content.
    change A1 for your reference.
    Last edited by KOKOSEK; 02-01-2019 at 12:24 PM.

  5. #5
    Registered User
    Join Date
    02-07-2013
    Location
    Istanbul
    MS-Off Ver
    Microsoft 365
    Posts
    19

    Re: Add Hyperlink According to the List

    Quote Originally Posted by KOKOSEK View Post
    So, do you want to keep Name-X as hyperlinks for each of Folder-X, right?

    Please Login or Register  to view this content.
    change A1 for your reference.
    Thank you KOKOSEK for alternative approach. As I have stated on previous posts I want H20 text not to be changed; that is H20 should contain a text not a formula. I am thinking that this could be done via macro that inserts hyperlink without changing the text of column H.

    I am trying to attached sample excel file but it seems I am not allowed.

  6. #6
    Registered User
    Join Date
    02-07-2013
    Location
    Istanbul
    MS-Off Ver
    Microsoft 365
    Posts
    19

    Re: Add Hyperlink According to the List

    Please find it attached sample excel file with first 3 entries hyperlinked as an example.
    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. Searchable Hyperlink List
    By wtfomgbbqftw in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-20-2014, 04:09 PM
  2. Using Vlookup to pull hyperlink from Master Hyperlink file list.
    By theflyingnimbus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-02-2013, 01:42 PM
  3. Hyperlink list
    By peteregan in forum Excel General
    Replies: 2
    Last Post: 12-28-2012, 07:24 AM
  4. Replies: 20
    Last Post: 03-19-2011, 09:13 AM
  5. Hyperlink List?
    By newbie13 in forum Excel General
    Replies: 3
    Last Post: 05-29-2008, 06:15 AM
  6. Hyperlink List
    By Pipestew in forum Excel General
    Replies: 2
    Last Post: 08-22-2007, 04:33 PM
  7. Hyperlink A List
    By SamuelT in forum Excel General
    Replies: 2
    Last Post: 08-06-2007, 06:16 AM

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