I have a list of webpages that do not increment in any logical order -- instead they are individually named.
I have built a macro that, theoretically, should do the following operation:
1) Start by taking data in Sheet2.A1 (the website URL in A1) and run a web-query wherein the entire page is returned to me in Sheet1.A1.
2) I then set Sheet2.B1 and Sheet2.C1 equal to Sheet1.A3 and Sheet1.A16 respectively.
3) I increment my counter and the next iteration should take the URL in Sheet2.A2, run the query and take the new data in cells Sheet1.A3 and Sheet2.A16 and place that data into Sheet2.B2 and Sheet2.C2, respectively. This is to loop 223 times. I can talk about catches later where we stop at null-valued cells or do this in batches.
Here is my VB script code:
Also, I am running MS Excel 2000. Thank you so much for your help!