Hello all, and thanks in advance for any help.

This is what I'd like to do:

A(date column) B(stock A price column) C(stock B price column)
6/18/07
6/19/07
6/20/07
etc.

How do I get the worksheet to fill in Columns B and C with the respective closing stock prices on each line for the date found in column A?

I suppose I use a web query, but I haven't been able to figure out how. (I'm not a proficient Excel user beyond the basics.)

BTW, if useful, a website that historical price quotes can be pulled from is http://bigcharts.marketwatch.com/historical/

Is this something simple that I'm too dumb to figure out? Thanks again everybody!