Hello All,

It's been a long time since I've done this, but I know it should be doable and relatively easy. Can someone help me with a script that scrapes specific data from a website with subpages numbered 1-999 i.e. webpage.com/999 (assuming a simple loop) and places into columns on a spreadsheet?
There appears to be no rhyme or reason to the order of the subpages, so some say "page not found 404" in the title section of the source code, but the existing pages are within the 1-999 range.
The specific data I'm looking to extract from the source code is in the exact same location on each existing page as "City" or "Country".
Is there a way to ignore the "pages not found" and export the data from the existing ones into rows on the spreadsheet (with a first column containing the associated URL)?

Thanks!