Thread
:
Referencing Cells in a Web Query
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Referencing Cells in a Web Query
I often use a macro to FIND some reference point and extract the data
desired to another location. Most use Yahoo instead of MSN. This can be
especially important for different versions of excel.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Mike" wrote in message
...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett