Create cell value as Hyperlink if Value matched with the pdf file name in a specific directory.

  • Hi,


    I have a large datasheet where AA9 to AA1200 have cells (Not all Cell currently have Value)

    I have directory E:\Bill\ where the pdf is located.

    The cell value and the pdf file name are the same.

    If the Cell value is matched with the pdf file name then the cell value creates the hyperlink.

    If nothing matched then skip.

    If New file is created and a new entry is made in between AA9:AA1200 then auto-matched & creates the hyperlink.


    Any help will be appreciated.


    Thanks in Advance.

  • Hi, I found a Solution and It worked

    Thanks.

  • Hi,


    Need help.

    The above code creates a hyperlink of cell-matched data from a folder if the pdf file exists.

    But if the cell in the excel file is blank then it also creates a random link to the existing pdf file.

    How to ignore this.


    If the cell is blank no hyperlink.

    Only hyperlink of matched data.


    Any help apricated .


    Thanks

  • See if this works