Help needed (creating VBA macro to retrieve stock info)

Hey,
I am fairly new to excel programming and just looking for some help on a personal project. (Please view file first to get and overview of what I'm looking to do)
I would like to create a VBA macro that would be able to retrieve stock info based on my worksheet. Moreover I would like to like the the vba macro to allow for database expansion (i.e. allow user to input new data on a daily basis (get alert info)

Any help is appreciated
Btw, would it be a good idea to later connect this file to Microsoft Access 2010?
Thanks,

you have not given complete information. what do you want? your sheets are not RAW sheets. you have already stated some pivot able in the second sheet and some filtering in the third sheet. Yo;u have also split the screen in the third sheet it would be easier to help you if the data is raw sheets and you explain what you want
all cosmetic changes may be made JUST BEFORE PRESENTATION TO YOUR BOSS OR USER.; (and not before the macros are written).



I presume you want the "open" price for the next day is to be filled in column H in sheet "E-mail data". you must be having some reason for naming this file like this
if you want open price of theose stocks then from where you would like to get. do you have already get some arrangement to get historical data. Perhaps you can get the IRET data for 7 Dec 2011 (G2 plus one day) from yahoo finance.
http://finance.yahoo.com/q/hp?s=IRET...=07&f=2011&g=d

in this webpage you see the name of the smbol IRET,the date 2011 7th day 11 means december because the month number starts form 0 for January
and g at the end is daily data;.

how you do it (if you have yahoo user id and password for any of their items like mail etc log in first )

open an excel sheet (2007)
click data
click import from web data (second icon from the left)
replace the existing web address to the above address and click go
when the data is downloaded click only the table you want by clicking yellow horizontal arrow and click IMPOT at the bottom and choose the cell where it is to be donwloaded
normallly A1 and click ok.
the data for 7th jan 11 will be downloaded and you can choose open price
a macro can be written changing the changeable in the web page like symbol and dates.

you can also download data into excel (open another sheet and download this data using "new web query")
do you want to download from yahoo finance or from some other data source

suggest post raw data sheets and explain.

tentatively I have written a macro for you. I am sending the file 'L80N.xlsm"
see the column H in sheet ("E mail data"
the open prices are filled by the macro
if you want to retest you can run the macro "test"

there is only one big problem. You have 334 stocks and mostly for each stock the date (co. G) is different ( may be one to three stocks may have same date). the macro downloads the rices for the next day to corresponding col. G dates and copy it to col H of the email data sheet. Temporarily the data is downloaded in sheet 3.

IT TAKES NEARLY 9 MINUTES TO FILL THE DATA BY THE MACRO
once you experiment with this with patience. meanwhile let me check whether some speedier solution can be made.
see the macro in the vb editor to understand the logic of the macro