View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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