Have you tried drag/copy down?

A3 will increment as you drag.

Click and hold on the cell then grab fill handle at lower right corner of cell
and drag down the column.

If you don't see a fill handle(black lump and cross) go to ToolsOptionsEdit
and check "allow cell drag and drop"

Gord Dibben Excel MVP


On Sun, 12 Dec 2004 14:37:12 -0800, "OzGhostRiding"
wrote:

Thanks Frank. Now apart from manually entering each hyperlink, a tedious job
for 1500 links is there a way I can apply that hyperlink to an entire column
so each code links to it's corresponding page?

"Frank Kabel" wrote:

Hi
in B3 enter:
=HYPERLINK("www.website.com/generic/" & A3 & "/" & A3 & ".html",A3)

--
Regards
Frank Kabel
Frankfurt, Germany

"OzGhostRiding" schrieb im
Newsbeitrag ...
I wish to link an excel pricelist to a company website with the
product
descriptions using the product codes listed in column A. There are
approximately 1500 product codes.
example:
Cell a3 has the value 12345
hyperlink is www.website.com/generic/12345/12345.html
and so on down the column.