Forum Discussion

Budman36's avatar
Budman36
Brass Contributor
Jan 01, 2020

Auto populate Hyperlinks in by dragging down a cell in office 365

I want to drag a cell down auto populating each next cell.  Ex.... MJN1001 through MJN1100... no problem, excels will allow this by the copy feature.  Each cell needs to hyperlink into a folder that ...
Formulas and Functions
Budman36's avatar
Budman36
Brass Contributor
Jan 04, 2020

SergeiBaklan 

Hello Sergei,

Your idea worked... part way.  I played with this, and got the hyperlink too populate, but it won't open the files.   The files are stored on a OneDrive.  Would that matter?   Here is an example of what I did.  I changed the directory names for security reasons, but the idea is the same. 

 

=HYPERLINK("C:\Users\John Smith\OneDirve-ABC Company. INC\ABC Folder\"&'Formula Page'!B107&"",Formula Page'!B107)

 

I have a hidden page on the ABC Folder that I call "Formula Page".  In this page I have all my folder numbers listed, so it displays the number on my main page vs. the hyperlink code. 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 04, 2020

Budman36 

It shall work with synced OneDrive folder. I played with my one:

=HYPERLINK("C:\Users\Sergei\OneDrive - ABC Inc\" & 'Formula Page'!B8,'Formula Page'!B8)

it opens the folder named in 'Formula Page'!B8 (e.g. Documents)

  • Budman36's avatar
    Budman36
    Brass Contributor
    Jan 04, 2020

    SergeiBaklan 

    Thank you.  I realized why it wasn't working when I saw your code.  I had the wrong file directory.   Sometimes a fresh look gets you to see what is in front of you. 

     

    thank you!

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 04, 2020

      Budman36 , you are welcome, glad to help

Resources