Hyperlinks in Excel

[Scooby Doo]

I need to access web pages that increment so want to create a list in Excel
that would make this easy. How can I do this?

Example, I want to increment http://website.com/index.php?ch=1. I want the
last number to increment by 1 up to 1200. When I do this in Excel it doesn't
recognise the text as a hyperlink, and I'm forced to update the link
manually. Is there any easy way?

Thanks

 

[Dave Peterson]

I'd use the =hyperlink() worksheet function:

=HYPERLINK("http://website.com/index.php?ch="&ROW(),
"http://website.com/index.php?ch="&ROW())
(one cell)

If you look at the help, you'll see that the first parm is the actual hyperlink
and the second is the friendly name shown in the cell.

I used the same for both, but you don't need to.

 

[Scooby Doo]

Dave, thanks a lot, thats just what I wanted. Even better as it allows me to
separate the hyperlink to the name.

Thanks again

 

[David McRitchie]

For a quick solution you can actually use the
http://website.com/index.php?ch=1
and use the fill handle to fill down, but the use of the
HYPERLINK Worksheet solution provided by Dave Peterson
allows you more options as you already indicated,
it would also allow you to concatenate parts of the
webpage name from other cells as well.

Of course with headings you would actually probably use
& ROW()-1 instead of & ROW()