Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How would I go about looking through a list of counties and retrieving all of
the countys' respective zip codes through a web site such as: http://www.getzips.com So I would have different territories set up in a reference area (e.g cells A2:S20 contain a list of counties - column A would containTerritory1, Territory2, Territory3 - Territory19 and columns B through S would contain each territories respective counties). Below (starting in cell A22) I would like to list out all zip codes, city and state and county names (all data that is shown from getzips.com) for each of the counties. The script would look through each county on the getzips.com website and output all zip codes for every county listed in the reference area. So if I wanted to lookup "bucks" county "pennsylvania" I could do so by following: http://www.getzips.com/CGI-BIN/ziplo...t=Lo ok+It+Up What would be the easiest way to go about doing this? I have several thousand counties that I would need this information for and I know this is possible with a script... Just not sure how to even begin. Please help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find all item codes for all items under one category | Excel Discussion (Misc queries) | |||
How can I find the alpha numeric codes in excel please,Thank you. | Excel Discussion (Misc queries) | |||
Cntrl find - cannot locate zip codes that start with zero. Possibl | Excel Discussion (Misc queries) | |||
find top 25 codes | Excel Worksheet Functions | |||
How to find out country-dependent Format Codes | Excel Programming |