Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a hyperlink, by placing data in a cell inside
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. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a hyperlink, by placing data in a cell inside
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? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a hyperlink, by placing data in a cell inside
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 "0o0o0" schreef in bericht ... 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? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting data from two cells to make a hyperlink | Excel Discussion (Misc queries) | |||
make the cell hyperlink to any name within it | New Users to Excel | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
How do I make a picture stay inside a cell? | Excel Discussion (Misc queries) | |||
Placing the target cell after a hyperlink is executed | Excel Programming |