hello, everyone.

I've been boiling my head over this with no success. what I basically wanna do is, I have a series of values on the first column (almost 500), and I want the values next to it to be retrieved from the internet, from an address based on that cell. here's a simple example (not exactly the data I'm looking for):

A....| B
GOOG | 8.91
MSFT | 7.65
YAHO | 8.21
.
.
.

whereas B1 is a value retrieved from http://www.quotes.com/?=GOOG (from A1).

then I'd copy B1 to B2 and it would retrieve that info from the same web address followed by /?=MSFT, and so forth.

I've created a .IQY file that does that and it works, but whenever I copy it to the next group of cells, it keeps the source as "A1" instead of changing it to "A2", even when I remove every "$" from the "parameters" part of the original cells. then I have to edit that link and manually change it to A2.

what I wanna do is pretty much retrieve info on several hundreds of stock market tickers, but that info is actually ratings from a specific web site.

any ideas? not sure it's even possible :/