Hyperlinking many cells to different .pdf files

S

swmasson

Hi there,

Can someone please help me?

I am just creating a excel spreadsheet links a drawing number to its
original pdf.

for example -

Drawing number = BPMGE034
pdf document number = BPMGE035 magpdf (1).pdf

I have over 1000 drawing numbers that i need to link to the pdf's but
when there is over 1000 it could take some time!!

All pdf drawing numbers start with the drawing number with the same
text added to the end as shown above " magpdf (1).pdf".

So what i need to know is how to create a sequence of hyperlinks with
the individual drawing numer to start followed by "magpdf (1).pdf".

Thank you

Regards

Steve
 
F

Frank Kabel

Hi Steve
if your values are in column a use the following formula in B1
=HYPERLINK(A1&" magpdf (1).pdf",A1)
and copy down
 
S

swmasson

Thank for that it nearly worked, it was my fault that it didnt, and
still dont understand what to do, sorry for being thick.

the folder dtrcture i am using is as follows:-

top two folders
excel (this is where i store my excel spread sheets)
drawings----->iso_drawings (this is where the drawings are located)

Could you please tell me what i would need to put into the formula tha
yu already gave me?

Thank very much

Stev
 
F

Frank Kabel

Hi
add the complete path information to this formula:
=HYPERLINK("path" & A1&" magpdf (1).pdf",A1)

e.g.
=HYPERLINK("C:\drawings\iso_drawings\" & A1&" magpdf (1).pdf",A1)
 
Top