I have an excel sheet with web addresses typed in Col D rows after rows running to several hundred lines with addresses in text format.( eg; www.cookfood.net)
I want to insert the hyperlink in Col A with the text address from col D for each line.
manually i have done for few as ( eg: line 2) :
go to cell D2,
press F2,
copy or cut text by highlighting the content in cell D2
go to A2
Ctrl K
Ctrl V
I need to repeat this for 100s of rows
can any one help write a macro in vb code please ?
I want to insert the hyperlink in Col A with the text address from col D for each line.
manually i have done for few as ( eg: line 2) :
go to cell D2,
press F2,
copy or cut text by highlighting the content in cell D2
go to A2
Ctrl K
Ctrl V
I need to repeat this for 100s of rows
can any one help write a macro in vb code please ?