I'm trying to use this for my stock-tracking Excel file. I previously used the actual (YahooFinance) Http-url for each stock as the HYPERLINK, but, for some reason these would get lost or messed up when I updated my stock-list. Now I am using a separate column for the urls and wish to use these urls as the hyperlinks for the actual stock names in a separate column. I have been trying to use the address for the urls (C6,C7, etc.) as the Link_location part of the hyperlink, and it seems that I had this working sometime back, but it no longer works when I click on the stock-names.
I have seen articles on the web that state that what I am trying to do is possible, but none of these articles say how to do it.