Change hyperlink 1

[ptrifile]

Lets say I have rows that show numbers 1-10. So in A1 it would be 1, cell A2 would be 2, Cell A3 would be 3 etc..etc. What I would like to do is be able to click on one of the cells and have it take you to a URL. So for example if I clicked on cell A1 it would take me to

http://www.test.com/test/1,

if i clicked on cell A2 it would take me to

http://www.test.com/test/2

and so on. Is this possible?

I have thousands of rows so I need to be able to do this automaticall and not just manually type in each URL for each cell. Any help or suggestions are much appreciated.

Thank you!

Paul

 

[SkipVought]

hi,

Check out the =HYPERLINK() function.

Let's say that C1 contained

http://www.test.com/test/

Then your formula in A1 could be...
[tt]
A1: =HYPERLINK($C$1&ROW())
[/tt]
...and copy down

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[ptrifile]

Thanks Skip, this is great! But what if the contents of A1 (the 1 in this case) is not right at the end of the URL like i stated in my original question but is more realistically like this

http://www.test.com/somethingelse/1/somethingelse?

Thanks for the help!

Paul

 

[ptrifile]

I think I may have figured this out using concatenate, it is not pretty but I think it will get the job done.

 

[kjv1611]

Skip, in:
=HYPERLINK($C$1&[highlight #FCE94F]ROW()[/highlight])

Why add the [highlight #FCE94F]ROW()[/highlight] piece?

What does that add?

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[SkipVought]

@Steve,

if I clicked on cell A[highlight]1[/highlight] it would take me to

http://www.test.com/test/

[highlight]1[/highlight], if i clicked on cell A[highlight]2[/highlight] it would take me to

http://www.test.com/test/

[highlight]2[/highlight] and so on.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[kjv1611]

OK, interesting. So it's a method to make use of Excel's RowNumber without needing to type anything extra. Gotcha.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[SkipVought]

@Steve, It’s not the way I’d design the sheet, but that’s what the OP wanted. I’d have a column of consecutive numbers, which is probably what you were thinking. I’d give the C1 range a range name also.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]