Hypertest link auto update

M

MJSlattery

I have a large list of stocks on a worksheet and each stock has a lin
to the NASDAQ stock site to retrive their stock report for a selecte
stock.

I would like a link for each stock that takes me directly to tha
stock's report.

The URL would be exactly the same with the exception of the change fo
each TICKER.

I already have a pointer which directs a data retrival macro to fetc
the correct stock's data from Yahoo. So the Ticker symbol is in col c
and can be incremented using the TICKER name as a counter to loo
through the ticker sympols.

Any sugestions?

Thank
 
Top