| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink Stock Ticker in Cell
Hello Everyone,
Is this possible with the Hyperlink formula, I want to hyperlink to http://moneycentral.msn.com/investor...g.asp?Symbol=a but on the Symbol=A, I want that A to actually be a cell say A1 where A will be in that cell. Is that possible. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink Stock Ticker in Cell
Try something like this:
=HYPERLINK("http://moneycentral.msn.com/investor/charts/charting.asp?Symbol="&A1,"MyStock") Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JavyD" wrote: Hello Everyone, Is this possible with the Hyperlink formula, I want to hyperlink to http://moneycentral.msn.com/investor...g.asp?Symbol=a but on the Symbol=A, I want that A to actually be a cell say A1 where A will be in that cell. Is that possible. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink Stock Ticker in Cell
Not quite Ron, takes me to the web page but stays stuck on the symbol entry,
it's waiting for input, I need it to pick up the ticker in the cell and open the page with the ticker already in it. You know what I mean. "Ron Coderre" wrote: Try something like this: =HYPERLINK("http://moneycentral.msn.com/investor/charts/charting.asp?Symbol="&A1,"MyStock") Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JavyD" wrote: Hello Everyone, Is this possible with the Hyperlink formula, I want to hyperlink to http://moneycentral.msn.com/investor...g.asp?Symbol=a but on the Symbol=A, I want that A to actually be a cell say A1 where A will be in that cell. Is that possible. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hyperlink Stock Ticker in Cell
This is what I used
=HYPERLINK(CONCATENATE("http://moneycentral.msn.com/investor/charts/charting.asp?Symbol=",A1),A1) Thanks for your help. I can't beleive I answered my own questions. LOL "Ron Coderre" wrote: Try something like this: =HYPERLINK("http://moneycentral.msn.com/investor/charts/charting.asp?Symbol="&A1,"MyStock") Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JavyD" wrote: Hello Everyone, Is this possible with the Hyperlink formula, I want to hyperlink to http://moneycentral.msn.com/investor...g.asp?Symbol=a but on the Symbol=A, I want that A to actually be a cell say A1 where A will be in that cell. Is that possible. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Hide hyperlink cell & replace with macros | Excel Worksheet Functions | |||
| Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
Linear Mode
