Results 1 to 2 of 2

Thread: Excel hyperlink

  1. #1
    New Lounger
    Join Date
    Nov 2012
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel hyperlink

    Hello all, I have gotten help here before and need some again. I am using excel 2010 and I'm trying to create a hyperlink. In my earlier version I used
    =HYPERLINK("\Leon County\Digital\01448\" &E:E & ".001.tif","#"&"\Leon County\Digital\01448\" &E:E & ".001.tif"&"#") This formula tells the hyperlink to look in column "E" for the document number and then go to folder "Leon County" then to folder "Digital" and finally into volume 01448 to find the doc. number. This worked great! I have used the formula below when I need the hyperlink to go to column "L" for the volume number and column "M" for the page number and it worked well together.
    =HYPERLINK("\Leon County\Digital\2013\" &L2 & "\" &M2 & ".tif","#"&"\Leon County\Digital\2013\" &L2 & "\" &M2 & ".tif"&"#")

    Now I need it to go to column "B" get the folder number and go to column "W" to get the document number

    =HYPERLINK("\Gaines County\Digital\2013\" &L2 & "\" &M2 & ".tif","#"&"\Gaines County\Digital\2013\" &L2 & "\" &M2 & ".tif"&"#")

    so what I need it to do is the following: the hyperlink formula should tell it to go to Gaines County folder, inside that folder is another folder called "digital" and look in that folder and find the folder for the year 2013, now inside the folder 2013 are more folders that are named in column "B" of my excel spreadsheet which is named instrument number, for the example below it will be 2013-2088, (there are 4500 folders in the 2013 folder). Once there it needs to go to column "W" to get the document number 2169092715. This document number will be inside column "B" in 2013-2088, the problem here the hyperlink does not work????

    HYPERLINK INST.NUM GRANTOR.LNAME GRANTOR.FNAME GRANTOR.MNAME GRANTOR.TITLE GRANTEE.LNAME GRANTEE.FNAME GRANTEE.MNAME GRANTEE.TITLE BOOK.TYPE BOOK.NUM PAGE.NUM NUM.OF.PAGES FILE.DATE FILE.TIME INST.DESC INST.DATE LEGAL.DESC AMOUNT BENEFICIARY DUE IMAGE
    HYPERLINK 2013-2088 SMITH GEORGE P HECK EXPLORATION COMPANY INC OPR 000 000 3 5/1/2013 09:14am OIL AND GAS LEASE 4/18/2013 OIL GAS & MINERAL LEASE W/142.55ACS OF W/2 OF SEC 122 BLK H D&W RR 2169092715

    Any help will be greatly appreciated!!!!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Manually create the hyperlink to get the exact text and compare it to the text generated by the formula to check for differences.

    Steve

Posting Permissions

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