Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    macro to hyperlink

    I have an excel file with a list 40,000+ files. The spreadsheet includes the full path for each file (see column C, attached file for the first few rows).
    What's the quickest way to hyperlink the files? If it's a macro, anyone have a copy I could use?

    Thanks.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi

    The quickest way is probably to add a formula in a spare column, say [N]:
    In cell [N2], enter this formula:
    =HYPERLINK(C20)
    ..then, to quickly copy this formula down to the end of the block of 40,000 rows, put the cellpointer in cell [N2] and double-click the small black square in the bottom-right corner (the cursor will 'change' to a + when you hover over the little black square)

    zeddy

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you.
    I figured there had to be an easy way...........

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •