Referencing Cells in a Web Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 - 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!
 
Back
Top