View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
YogS
 
Posts: n/a
Default Copy hyperlink from one cell to/as hyperlink in another cell

Hello All
Probably my question was not clear

I have data like
No. ID
1 dts0100309695
2 dts0100309692
3 dts0100309688
4 dts0100309338
5 dts0100309323
6 dts0100309313
7 dts0100309310
8 dts0100309235
9 dts0100309229
10 dts0100309204
11 dts0100292049


The data under column "No." contains hyperlink. I want to copy
hyperlink from entries in column "No." as hyperlink to corresponding
entry in Column "ID"

eg if entry "1" in column "No." contain underlying hyperlink "
www.google.com" I want to copy this hyperlink as hyperlink to
corresponding entry "dts0100309695" in column ID

Regards
YogS