Find keyword and insert hyperlink to cell
 

Hi all,

I want to write a macro that will look for a keyword in a range of
cells and return a hyperlink to the cell with the keyword in it. I
want the hyperlink to be inserted into another worksheet from cell A1
downwards.

Any suggestions would be much appreciated.

Thanks
Sarge III