Need help with reverse phone lookup
Hi, I have a list of phone numbers of various companies that I need the addresses for. I have about 500 numbers that I need the address, city, state, and zipcode for. I do not want to manually lookup the numbers by typing them into a website (such as anywho) manually. I have all of the phone numbers in excel already. Does anyone know if there is a macro for formula that will automatically look up the address for a phone number in excel? Any help would be greatly appreciated and would save me a bunch of time from manually looking up each number. Thanks, Steve B Boulder, CO -- steve2003 ------------------------------------------------------------------------ steve2003's Profile: http://www.excelforum.com/member.php...o&userid=24446 View this thread: http://www.excelforum.com/showthread...hreadid=380446 |
You might be able to create a VBA procedure which will run a web query over
and over, depending on which version of Excel you have and how important this is... "steve2003" wrote in message ... Hi, I have a list of phone numbers of various companies that I need the addresses for. I have about 500 numbers that I need the address, city, state, and zipcode for. I do not want to manually lookup the numbers by typing them into a website (such as anywho) manually. I have all of the phone numbers in excel already. Does anyone know if there is a macro for formula that will automatically look up the address for a phone number in excel? Any help would be greatly appreciated and would save me a bunch of time from manually looking up each number. Thanks, Steve B Boulder, CO -- steve2003 ------------------------------------------------------------------------ steve2003's Profile: http://www.excelforum.com/member.php...o&userid=24446 View this thread: http://www.excelforum.com/showthread...hreadid=380446 |
I ended up using a windows-based macro program to copy the phone number and paste it into anywho, wait a few seconds, and then paste the retrieved data back into excel. Thanks for the help. -Steve -- steve2003 ------------------------------------------------------------------------ steve2003's Profile: http://www.excelforum.com/member.php...o&userid=24446 View this thread: http://www.excelforum.com/showthread...hreadid=380446 |
All times are GMT +1. The time now is 09:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com