Hyperlinks

  • Thread starter Thread starter Gerard Goodland
  • Start date Start date
G

Gerard Goodland

Hi all,

I have a sheet with approx 100 rows. In Col F there is an alphanumeric
entry( 021RFF for example). On the hard drive there is a file with the
coresponding name ( C:Files\021RFF.xls). I want to get a hyperlink to
the value in the F col cells without having to manually add a hyperlink
in all rows.So would it be c:\Files\"F3".xls or what?

Thanks
 
You could use a worksheet double click event and in it have the selected
cell tied into a follow hyperlink macro.
 
Back
Top