I have column A full of lots of URLs and they each return a basic string of text.
Two examples:
I am looking for a piece of VBA that would look at the first URL and pull the data, paste it in to column B and then move to the second URL and pull the schedule and so on until they have all been pulled.
Thanks in advance for any advice.
Two examples:
https://www.manchester.gov.uk/site/custom_scripts/bin_dates_gazops/index.php?uprn=000077002036 |
https://www.manchester.gov.uk/site/custom_scripts/bin_dates_gazops/index.php?uprn=000077002225 |
I am looking for a piece of VBA that would look at the first URL and pull the data, paste it in to column B and then move to the second URL and pull the schedule and so on until they have all been pulled.
Thanks in advance for any advice.