I have a list of about 1000 stock symbols that I want to update with web queries (if possible).

If column A is a list of 1000 stock symbols, and column B has the URL for the stock quote, is there a way to put a web query in column C that references the URL in column B in such a way that the web query can be copied down the entire column C, changing the URL reference from B2 to B3, B4...etc, as it is copied down?

Thanks.
Jim