Distance determination, ZIP code matching
Posted on 2009-02-18
This is a one-time data determination. After I generate this list, I will probably never need to generate it again. I need to find the closest (as the crow flies) US government weather station to each US ZIP code. I have the latitude and longitude for each weather station (2100 stations) and for each US ZIP code (41,000 ZIP codes). I would like to carry out this data generation in Microsoft Excel 2000. There is probably a simple VBA solution, but I am not skilled in VBA. Thanks in advance.