Posts by andrew007uk

    Hi,


    Firstly, I want to say that I am not an advanced user of excel, but I can get myself around most things.



    I have a spreadsheet that I enter invoice numbers in column B of my spreadsheet. In column C I have the following hyperlink:


    =IF(B3="","",HYPERLINK(FileLocation&DriveLetter&FileLocation2&B3&".pdf",B3))


    The above hyperlink is representative of what is in cell C3. This is copied all the way down column C and the ‘B3’ above, just increments as the cells go down column C.



    FileLocation = ‘file://


    DriveLetter= C:


    FileLocation2= '\Users\Andrew\OneDrive\Documents\Accounts\2018 Accounts\Invoices 2018\


    [TABLE="border: 1, cellpadding: 1, width: 500"]

    [tr]


    [td][/td]


    [td]

    B (Invoice No.

    [/td]


    [td]

    C (Hyperlink is in this column

    [/td]


    [/tr]


    [tr]


    [td]

    1

    [/td]


    [td]

    1655

    [/td]


    [td]

    =IF(B1="","",HYPERLINK(FileLocation&DriveLetter&FileLocation2&B1&".pdf",B1))

    [/td]


    [/tr]


    [tr]


    [td]

    2

    [/td]


    [td]

    1656

    [/td]


    [td]

    =IF(B2="","",HYPERLINK(FileLocation&DriveLetter&FileLocation2&B2&".pdf",B2))

    [/td]


    [/tr]


    [tr]


    [td]

    3

    [/td]


    [td]

    1658

    [/td]


    [td]

    =IF(B3="","",HYPERLINK(FileLocation&DriveLetter&FileLocation2&B3&".pdf",B3))

    [/td]


    [/tr]


    [tr]


    [td]

    4

    [/td]


    [td]

    1651

    [/td]


    [td]

    =IF(B4="","",HYPERLINK(FileLocation&DriveLetter&FileLocation2&B4&".pdf",B4))

    [/td]


    [/tr]


    [/TABLE]


    The above works fine, but it uses up 2 columns of my workbook. What I would like to do is just enter an invoice number in column B and when I press on it, it will open a PDF file that represents the invoice number.


    Is there a solution to this problem?


    Kind Regards


    Andrew