+ Reply to Thread
Results 1 to 2 of 2

Dynamic Hyperlink

  1. #1
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Dynamic Hyperlink

    Hello,
    In Cell A1 I have a filepath such as:
    E:\MyFolder\Doc.pdf
    E-drive is a Thumb Drive
    This filepath is created with:
    CONCATENATE(LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1), "Doc.pdf")
    I am trying to have a Formula in A2 which would Hyperlink cell A2 to the address in A1.
    The purpose is that if I copy MyFolder to another drive, say C, than in A1 I will get
    C:\MyFolder\Doc.pdf
    But now I want the Hyperlink to relate to the same doc but on C drive;
    A kind of “dynamic link”
    Is this possible?
    Thanks

  2. #2
    Forum Contributor
    Join Date
    03-02-2014
    Location
    usa
    MS-Off Ver
    MS 365
    Posts
    593

    Re: Dynamic Hyperlink

    OK, I found the answer under similar posts; i was not aware of the Hyperlink formula
    Thanks

+ 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. Dynamic Hyperlink
    By lstevenson in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-14-2015, 11:50 PM
  2. [SOLVED] Dynamic Hyperlink
    By gan_xl in forum Excel General
    Replies: 5
    Last Post: 08-21-2013, 10:21 AM
  3. Dynamic Hyperlink
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2012, 04:20 PM
  4. Dynamic Hyperlink
    By nazimscr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2011, 05:50 AM
  5. [SOLVED] Dynamic Hyperlink
    By Larry S in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-17-2006, 07:25 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