Forum Discussion
Auto populate Hyperlinks in by dragging down a cell in office 365
If your first hyperlink is in cell A2 that could be like
=HYPERLINK("file://c:\MJN" & (1000+ROW()-ROW($A$1)))
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.
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)
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!
