Make a hyperlink, by placing data in a cell inside

  • Thread starter Thread starter 0o0o0
  • Start date Start date
0

0o0o0

Say you have an excel file with stocks on it..
in the first list..

MSFT News
WIN.to News
JBOH News
AMTD News

all in the first row.. I want to make.... a link say
www.stockquotes.com/bla/bla/symbol= (cell) /bla/bla.htm
So I can see the news.

how would I make it auto fill one of the stocks above.. and be blue
clickable?

In query you can make it so it refers to the link as what evers in cel
say A1 , it'll place it in the link. But I dont want the info to be
pulled to the excel page, I want to be taken to the browser to see the
news.
 
they are just strictly stock symbols in the cells.... and the word news
is in another cell.. thats the think I want clickable.. but I want
excel to automatically grab the symbol to the left.. and autofill
somehow into the link for the news. And be clickable when I press on
news for that stock??

The symbols on the left are ALWAYS changing cause that is the result of
a bunch of ather sheets calculated together to get this symbol on this
page..

confusing?? anyhow how do i get the text in cell A1 into a hyperlink on
cell F1??
Whats the wild key or command?
 
Hi,

You can concatenate the text in different cells in to one (hidden) cell,
then in another cell you can make a hyperlink with that (hidden) cell.
So if you have in
A1: businesssolutions
A2: default.mspx
and you want the user to go to microsoft.com on the businesssolutions page,
then enter in a cell in a hidden row or column, eg A3:
="http://www.microsoft.com/" & A1 & "/" & A2

In the cell the user can click to go to the webpage eg A4:
=Hyperlink(A3; "Go to " & A1)

I hope this is what you're looking for

Roland
 
Back
Top