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