Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
Ok. This one isn't mine, I was just asked to find out if it's even possible (personally, I don't think it will be, but I guess we do anything for our loved ones, don't we? :wink
My husband has a spreadsheet that has address info of about 7,100(+/-) companies.
Unfortunately, none of these have the zip codes.
He would like to know if there is some way to set up a macro or something to look at the cells with the city and state, determine the correct zip code and have that automatically entered into a blank cell.
Would any of you out there have any ideas other than having to go through the USPS zipcode lookup on their site?
Thanks a bunch, guys!
My husband has a spreadsheet that has address info of about 7,100(+/-) companies.
Unfortunately, none of these have the zip codes.
He would like to know if there is some way to set up a macro or something to look at the cells with the city and state, determine the correct zip code and have that automatically entered into a blank cell.
Would any of you out there have any ideas other than having to go through the USPS zipcode lookup on their site?
Thanks a bunch, guys!