I have a workbook that has a column which contains the titles of different documents which are published to a website (B4:B6). Another column contains the URLs for those documents (C4:C6).
<tbody>
</tbody>
I have a user who is used to manually inserting a hyperlink into the cell which contains the title, so that the title cell points to the URL. He wants the title cells to be hyperlinked, understands the need to have the hyperlink in its own cell for reference purposes, but doesn't want to re-type or copy-paste the URL. How do I setup the URL cells (C4:C6) to check the title cells for embedded hyperlinks, and if it finds one, to replicate it in the appropriate URL cell?
Alternatively, how do I setup the title cells to check the URL cells for text, and if it finds some, to automatically apply that text as a hyperlink in the appropriate title cell?
And worst of all, how do I do this without using VBA/macros?
Helper columns are totally fine if necessary.
| Document Title | External Link |
| How to Eat Worms | www.fakewebsite.com/how-to-eat-worms |
| How to Dig a Hole | |
| How to Avoid Looking Directly at the Sun |
<tbody>
</tbody>
I have a user who is used to manually inserting a hyperlink into the cell which contains the title, so that the title cell points to the URL. He wants the title cells to be hyperlinked, understands the need to have the hyperlink in its own cell for reference purposes, but doesn't want to re-type or copy-paste the URL. How do I setup the URL cells (C4:C6) to check the title cells for embedded hyperlinks, and if it finds one, to replicate it in the appropriate URL cell?
Alternatively, how do I setup the title cells to check the URL cells for text, and if it finds some, to automatically apply that text as a hyperlink in the appropriate title cell?
And worst of all, how do I do this without using VBA/macros?
Helper columns are totally fine if necessary.
