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