+ Reply to Thread
Results 1 to 3 of 3

Hyperlink autofill

  1. #1
    Registered User
    Join Date
    07-29-2015
    Location
    Hong Kong
    MS-Off Ver
    2007
    Posts
    14

    Hyperlink autofill

    How can i linked the RED to "15-771.pdf" and need autofill function?
    For example:
    15-0772 <------ linked to "Hard%20copies\2015\15-0772.pdf"
    15-0773 <------ linked to "Hard%20copies\2015\15-0773.pdf"
    15-0774 <------ linked to "Hard%20copies\2015\15-0774.pdf"
    15-0775 <------ linked to "Hard%20copies\2015\15-0775.pdf"
    15-0776 <------ linked to "Hard%20copies\2015\15-0776.pdf"
    15-0777 <------ linked to "Hard%20copies\2015\15-0777.pdf"



    =HYPERLINK("Hard%20copies\2015\"&ROW(B782)&".pdf","0"&ROW(B771))
    Last edited by lkikl; 07-30-2015 at 04:09 AM.

  2. #2
    Registered User
    Join Date
    08-04-2009
    Location
    Golborne England
    MS-Off Ver
    2013
    Posts
    85

    Re: Hyperlink autofill

    Hi There,

    I use this with great success on a list of pricing amendment that I track. I just keep copying it down as my list gets longer.


    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-29-2015
    Location
    Hong Kong
    MS-Off Ver
    2007
    Posts
    14

    Re: Hyperlink autofill

    It's doesn't work and i tried to

    =HYPERLINK("Hard%20copies\2015\"&"15-771"&".pdf", "0"&ROW(B771))

    the hyperlink still cannot autofill

+ 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. Autofill base on Active Cell and Autofill by row count of another sheet
    By enyak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2014, 10:06 PM
  2. Hyperlink Autofill
    By Shribbles in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-08-2013, 03:59 PM
  3. [SOLVED] Very small AutoFill macro showing "AutoFill methode of range class failed" why ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 10:21 PM
  4. Macro for Autofill removes header info when there is no data to autofill
    By esturan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 01:42 PM
  5. Autofill a hyperlink into workbook?
    By Andydayuk in forum Excel General
    Replies: 0
    Last Post: 10-16-2009, 01:30 AM
  6. Replies: 1
    Last Post: 06-17-2005, 04:05 PM
  7. Replies: 0
    Last Post: 03-02-2005, 12:06 PM

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