Series with HyperLink

[opazzo]

Hi All,

Here is my situation : i 've got a column A with sequential numbers like this

1
2
3
4


On each cell of this column there is an hyperlink to a file named with the same number

1 got an hyperlink to 1.pf
2 got an hyper link to 2.pdf and so on

I dont' want to do this one cell by one cell because i have more than a thousand to do.

How could I easily make a serie which will link the right file with the right cell number.

Thanks

 

[GlennUK]

Have a look at the HYPERLINK function. That should do exactly what you want.

 

[opazzo]

Thanks Glenn, but i stil can't find a way to make a serie out of this.
If i drag the cell down, no serie is made.

 

[GlennUK]

Without you posting the formula you have tried, how I am supposed to see what is wrong with it?

 

[opazzo]

Here we go :

A1133
=HYPERLINK("H:\projet\ROCs\ROCs e-files\01) ROC all by numbers\ROC-1125.pdf",1125)

Can't make a serie out of this.

I'd like next cell down(A1134) to be linked to ROC-1126.pdf with firendly name 1126 and so on...

Thanks for your support.

 

[GlennUK]

Here you are:

for cell A1133
=HYPERLINK("H:\projet\ROCs\ROCs e-files\01) ROC all by numbers\ROC-"&ROW()-8&".pdf",ROW()-8)

 

[opazzo]

Does that work for you ?

I've got an error message. The function box tells that the path is not valid.

I guess that the problem come from the row() included.

Any ideas ?

Thanks again

 

[GlennUK]

Does the original formula that you gave me actually work?

This one, I mean:

=HYPERLINK("H:\projet\ROCs\ROCs e-files\01) ROC all by numbers\ROC-1125.pdf",1125)

 

[opazzo]

Yes Sir

 

[GlennUK]

And in which cell did you put my new formula?