Hyperlink to files?

  • Thread starter Thread starter MPSingley
  • Start date Start date
M

MPSingley

If i have a list of drawing numbers.. such as 2200034567, 2200034568
in a column in excel, with a description of each file in the next
column over, and all of those files are located in one folder.. is
there a way i can use one general equation to have excel search for
that file in the folder and open it if you clicked on the 22 number?

Thanks for any help in advance!!


i know there are ways to do it.. i just dont have the time to
hyperlink 15,000 drawings...
 
Maybe you can just one formula and copy that formula down 15000 rows.

Put the folder in a cell (I used A1):

Then with the data in A2:A15000, I put this in A2:
=hyperlink("file:////" & $a$1 & a2, "Click me")

Make sure that the folder in A1 ends with a backslash.
 
Back
Top