H
Heath
Windows 2000 Pro and Excel 2000
I have a worksheet with a table of information, included in this table
are hypolinks.
First colunm of the table is a ref number.
Secound is a discription.
Third has different URL's
(There are other colunms)
Secound worksheet has a colunm where I enter the ref number and the
following cells self populate from that ref number useing the
following
=VLOOKUP(B24,Intro!G33:L192,2,0)
However this only populates the new cells with the text from the first
sheet
and doesn't insert the hyperlinks.
Any idea how I can get it to transfer the hyperlinks as well as the
displayed
text.
I have a worksheet with a table of information, included in this table
are hypolinks.
First colunm of the table is a ref number.
Secound is a discription.
Third has different URL's
(There are other colunms)
Secound worksheet has a colunm where I enter the ref number and the
following cells self populate from that ref number useing the
following
=VLOOKUP(B24,Intro!G33:L192,2,0)
However this only populates the new cells with the text from the first
sheet
and doesn't insert the hyperlinks.
Any idea how I can get it to transfer the hyperlinks as well as the
displayed
text.