I have an excel document with col A containing numbers from 1 to 2000. I want to apply a hyerlink to each of those numbers based on the hyperlink based on the col G. I want to create a series of hyperlinks by creating one and then copying them down a column with each hyperlink pointing to the same column but the next row (just as it would if you copied a formula down the column).

How can I do that?

You will of course have discovered that you cannot drag the cell down, however you can drag the row. You may want to create your first hyperlink in the correct position in an empty worksheet, then click on the row number, select the little black box, I don't know the correct tech term, whence your mouse indicator will turn to a cross, and drag down.
Then copy and paste the result into its correct place.

Sorry for the non tech terms the old grey matter has gone fuddled:D

Brian

edit You will of course have to copy and paste the whole column.

I think I need to explain this better
I have an excel file with 2 colm

Colm A Colm B
E0001 ../EastPages/E0001.html
E0002 ../EastPages/E0002.html
E0003 ../EastPages/E0003.html
E0004 ../EastPages/E0004.html
this continues for 2000 pages

Colm A are the titles
Colm B are the hyperlinks

When I apply =Hyperlink(B1) in cell A1 I loose the title

Colm A
../EastPages/E0001.html (Title is gone)

I need to apply the hyperlink without loosing the title.

I know you can go to the menu and Insert a hyperlink and keep the title. But to do this too 2000 titles. WOW
I tried coping down the titles that works but it still refers to the original link.

That is why i wanted to go to the formula =hyperlink

Now the tricky part
I want to create a series of hyperlinks by creating one and then copying them down a column with each hyperlink pointing to the same column but the next row (just as it would if you copied a formula down the column). But still maintain the title.


Thanks

Sorry misunderstood what you were doing, and unfortunately cannot help.

Brian