How can I build a work sheet to get stock quotes and put the quote in a
different cell A5, A6, A7 every day. Can this worksheet update itself
daily?

sctroy


--
sctroy
------------------------------------------------------------------------
sctroy's Profile: http://www.excelforum.com/member.php...o&userid=25928
View this thread: http://www.excelforum.com/showthread...hreadid=482265

yes it can be done
you need the url of the webpage from which you can download into Excel
sheet(use data-get external data (or import data) (web query)
and then you copy the relevant cell to some otehr cells preferably to some
other sheet.-e.g. sheet2
next day you delete the previous days downloaded data and download fresh
data and copy.

you can create a vba for the whole process

--
remove $$$ from email addresss to send email

==================


"sctroy" wrote in
message ...

How can I build a work sheet to get stock quotes and put the quote in a
different cell A5, A6, A7 every day. Can this worksheet update itself
daily?

sctroy


--
sctroy
------------------------------------------------------------------------
sctroy's Profile:
http://www.excelforum.com/member.php...o&userid=25928
View this thread: http://www.excelforum.com/showthread...hreadid=482265