View original (French)

Link hypertext incrementing

Solved
Mikasims Posted messages 2 Status Member -  
Mikasims Posted messages 2 Status Member -
Hello,

I’m looking for how to create hyperlinks in Excel, for example: NU00001 (in one cell), and in the cell to its right, the link that opens a PDF. For example:

[NU00001][O:\BE_production\CLICHES SAP\NU00001.pdf]
[NU00002][O:\BE_production\CLICHES SAP\NU00002.pdf]
[NU00003][O:\BE_production\CLICHES SAP\NU00003.pdf]
ETC, ETC

Thank you

1 answer

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    In the cell to its right, the link that opens a PDF, with this formula for example: 
    =HYPERLINK("O:\BE_production\CLICHES SAP\"&A2&".pdf";"Open "&A2)

    and you can "drag" the formula across the column (with the small square at the bottom right).
    --
    Always zen
    Perfection is not reached when there is nothing more to add, but when there is nothing left to remove. Antoine de Saint-Exupéry
    0
    1. Mikasims Posted messages 2 Status Member
       
      Hello,

      Thanks for your help, it’s awesome, a HUGE time saver.....

      it’s magiiiiqqquuuueeee.

      Have a nice day.

      micka.
      0