Hi all,

I'm pretty good with excel, but not at VB. What i want to do is have some data tables for about 20+ stocks with about 2 weeks' worth of Yahoo most recent price data feed into my excel file at the close of each trading day. I will use these dynamically updating tables to feed into some other data in the same worksheet. Can anyone tell me if it is possible to have some standard tables in a worksheet update automatically by means of a macro? What I want to avoid doing is having to manually reload the closing information each day into excel for these 20 or so tickers. That takes about 20 minutes a pop, whereas with a macro this could be instantaneous. Thanks