Hi again all, I'm think I made my first post too wordy and overly complicated things.....
I have a column of URLs in column A of "Sheet1". I have a web Query on "Sheet2". I want a macro to loop through all URLs in column A of "Sheet1", changing the WebQuery to use the URL as it's connection, copy cell A1 of the web query on "Sheet2", and paste that value to column B of "Sheet1" right next to the URL it is coming from.
IE, A1 contains URL 1
Macro will have web query go to URL1, copy A1, and paste to B1
A2 contains URL 2
Macro will have web query go to URL2 copy A1, and paste to B2
etc...
Hopefully that is a clearer proposition, any idea how I might go about getting this done?
I have a column of URLs in column A of "Sheet1". I have a web Query on "Sheet2". I want a macro to loop through all URLs in column A of "Sheet1", changing the WebQuery to use the URL as it's connection, copy cell A1 of the web query on "Sheet2", and paste that value to column B of "Sheet1" right next to the URL it is coming from.
IE, A1 contains URL 1
Macro will have web query go to URL1, copy A1, and paste to B1
A2 contains URL 2
Macro will have web query go to URL2 copy A1, and paste to B2
etc...
Hopefully that is a clearer proposition, any idea how I might go about getting this done?
