Hyperlink properties only from one cell to another.
 

Is there a way to copy the hyperlink property only from one cell or
column of cells to another? I originally wanted all cells in my rows
to have the same hyperlink. But then I realized I had to insert a
column (B) that doesn't have a hyperlink. After I did this I lost the
hyperlink to column (A) but still have it in (C) & (D).
Thanks in Advance,
k.