ExcelBanter - Generate absolute hyperlinks to cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Generate absolute hyperlinks to cells (https://www.excelbanter.com/excel-discussion-misc-queries/49410-generate-absolute-hyperlinks-cells.html)

Loïc

Generate absolute hyperlinks to cells

I want to know how to add an hyperlink to a cell. In one column I have the
name of the movies and in the second column I have the hyperlinks to Amazon
shop. So I want to obtain the following result if possible :
<A HREF="B1"A1<BR</A
<A HREF="B2"A2<BR</A
......

Thanks for your help !

Loïc

All times are GMT +1. The time now is 10:26 PM.