I am trying to compile a list of record inspections posted by my city on the web. I have a list of urls (about 3,000) of individual inspection records.
Is there any way for me to run a script that will query each of these websites in sucession and post the results on a worksheet?
If I paste the list of URLs into a worksheet, is there a way to have a script that will query the URL in A1, then A2, then A3, etc....?
I am quite new to Excel and not a programmer (which is probably obvious from my question ;).
Thanks for any help!