Web site plus excell

P

Paula

I have a list of stock in my excell sheet and I update the price of the stock
with a website (yahoo/finance). Is there any way to do this automotically, I
mean when I open the page of yahoo/finance and the excell sheet it is updated
automatically?
Any suggestion or help, thanks a lot in advance.
 
J

Jim Thomlinson

The update can not be done as you have indicated becuase XL will have no idea
when you have opened your web page. What you can do however is have XL
perform a web query. Data -> Get External Data -> Web Query...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top