+ Reply to Thread
Results 1 to 5 of 5

Transfer hyperlink in autofill columns

  1. #1
    Registered User
    Join Date
    11-02-2016
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    3

    Transfer hyperlink in autofill columns

    =IFERROR(INDEX('Customer records'!$A$3:$D$499,'Customer records'!$G3,4),"")

    Above is the formula I am using to transfer information from one page to another. I am building a customer database that has hyperlinks to files containing paperwork on jobs and information for the machines we have worked on along with pictures. I have a main page with a customer selection list and then a table populates with all of the customer's info and machines. On a separate sheet I have a table with all of the customers, it would be inconvenient to have to scroll through this list to find that one job I'm looking for so I need to transfer all the info for one specific customer to one page, I have accomplished that but the hyperlinks do not transfer. Could I get some advice on what I need to add to get the links to transfer? I can't provide screenshots or the file itself
    Attached Files Attached Files
    Last edited by dmeredith; 11-03-2016 at 10:35 AM.

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Transfer hyperlink in autofill columns

    Try:

    =HYPERLINK(IFERROR(INDEX('Customer records'!$A$3:$D$499,'Customer records'!$G3,4),""))

  3. #3
    Registered User
    Join Date
    11-02-2016
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    3

    Re: Transfer hyperlink in autofill columns

    Still not working, populates with a link but it does nothing. I did up a quick sample template of what I'm trying to accomplish, I am transferring info from Sheet2 to populate Sheet1, the column that says LINK would have a hyperlink to a file on my pc and that hyperlink would transfer over to Sheet1 in the same column and be clickable.
    Attached Files Attached Files
    Last edited by dmeredith; 11-03-2016 at 10:36 AM.

  4. #4
    Registered User
    Join Date
    11-02-2016
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    3

    Re: Transfer hyperlink in autofill columns

    That worked, it didn't work the first time because the link itself was broken. Thanks for the reply.

  5. #5
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Transfer hyperlink in autofill columns

    Glad I could help, if that takes care of your issue could you please mark the thread as solved, and feel free to add reputation by clicking the star icon if you feel it's deserved.

+ 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. Hyperlink autofill
    By lkikl in forum Excel General
    Replies: 2
    Last Post: 07-30-2015, 05:28 AM
  2. Hyperlink Autofill
    By Shribbles in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-08-2013, 03:59 PM
  3. [SOLVED] Use hyperlink to transfer data from a specific row to another sheet.
    By chriswhite1982 in forum Excel General
    Replies: 4
    Last Post: 05-29-2013, 06:23 AM
  4. [SOLVED] Hyperlink transfer to PDF
    By kissmydrone in forum Excel General
    Replies: 2
    Last Post: 11-10-2012, 04:02 PM
  5. Transfer Data To Another Worksheet And Create Hyperlink
    By jasono in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-23-2011, 06:42 PM
  6. Autofill a hyperlink into workbook?
    By Andydayuk in forum Excel General
    Replies: 0
    Last Post: 10-16-2009, 01:30 AM
  7. How to transfer email hyperlink to another cell
    By Peepster in forum Excel General
    Replies: 2
    Last Post: 03-29-2005, 05:06 PM

Tags for this Thread

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