Referencing Cells in a Web Query
I am using Excel 2003. I am using a web query to collect financial data for
companies listed on the stock market. Mostly my web queries use
msn.moneycentral.com. I use the data to perform various calculations and
display the results on one worksheet. My problem is that when I change
stocks, the data sometimes moves cells which in turn errors my calculations.
Is there a way to fix this problem?
|