Without knowing what the details are, maybe you can use the worksheet function
=hyperlink()
=hyperlink(a1)
=hyperlink("http://" & a1 & ".com")
depends on what you have in A1 and what needs to be used for the link.
I'd insert a helper column, get one formula correct and drag down.
Me wrote:
I have a need to pass the value of a cell
into hyperlink how can this be done?
I want to create a hyperlink for the entire column.
Is there any way I can specify without specifying for each
column, it should pass the value of the column to this
hyperlink.
Thanks in advance,
-Me
--
Dave Peterson
|