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?

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?

Referencing Cells in a Web Query
 

Don - I don't have any experience with running macros. Do you know of any
good online references? or could you point me in the right direction? I've
looked at setting up a macros in Visual Basic, but I don't even know where to
begin. I appreciate any further advice!

"Don Guillett" wrote:

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

Referencing Cells in a Web Query
 

Go herejoinlook in the files section for free files that may be of help. I
have some there under the author donaldb36

http://tech.groups.yahoo.com/group/xltraders/files/

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike" wrote in message
...
Don - I don't have any experience with running macros. Do you know of any
good online references? or could you point me in the right direction? I've
looked at setting up a macros in Visual Basic, but I don't even know where
to
begin. I appreciate any further advice!

"Don Guillett" wrote:

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