I got a CSV file which looks like this when i open up in excel
COLUMN A
M
MSFT
KSS
AMZN
For each of the cell in column I would like to Macro to get the data from the web using the query xyz://finance.yahoo.com/q/ks?s="&$A$1&"+Key+Statistics","table", 11
when I execute the Macro, it should go to first M and execute the query (xyz://finance.yahoo.com/q/ks?s="&$A$1&"+Key+Statistics","table", 11) and fetch results into Column B 1
when I execute the Macro, it should go to first MSFT and execute the query (xyz://finance.yahoo.com/q/ks?s="&$A$1&"+Key+Statistics","table", 11) and fetch results into Column B 2
Any help in this matter is greatly appreciated. I am challenged with Macro code.