Killer macro idea for business mailings

R

Robert Blackwell

One of you programmers should write a macro to validate a city from zip
code. I receive excel files from response cards and a lot of people will put
some random letters for their city instead of the actual city name, or maybe
they'll put the wrong abrieviation for their state. It would be awesome if
all the zipcodes could validate the state field and change if necessary and
the same for the city fields too.

Okay, have at it :)
 
R

Robert Blackwell

Okay, well good idea I think anyways, but it turns out that my columns just
weren't wide enough so it didn't display more then 2 letters.
 
Top