Is there a way to take a hyperlink from one column and assign it to the text in another column? We have an automated report that lists document names in column B and a link to the document in column D. I need to have the link from D assigned to the title in B for each line in the spreadsheet so I can tranfer that data to a Word document and publish it as an htm file.
Marci