Series with HyperLink

opazzo

Board Regular
Joined
Dec 21, 2005
Messages
65
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
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Have a look at the HYPERLINK function. That should do exactly what you want.
 

opazzo

Board Regular
Joined
Dec 21, 2005
Messages
65
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

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Without you posting the formula you have tried, how I am supposed to see what is wrong with it?
 

opazzo

Board Regular
Joined
Dec 21, 2005
Messages
65

ADVERTISEMENT

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

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Here you are:
Code:
for cell A1133
=HYPERLINK("H:\projet\ROCs\ROCs e-files\01) ROC all by numbers\ROC-"&ROW()-8&".pdf",ROW()-8)
 

opazzo

Board Regular
Joined
Dec 21, 2005
Messages
65

ADVERTISEMENT

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

Well-known Member
Joined
Jul 8, 2002
Messages
11,547
Does the original formula that you gave me actually work?

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

Forum statistics

Threads
1,141,096
Messages
5,704,312
Members
421,338
Latest member
Pepess

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top