Need help with reverse phone lookup

[steve2003]

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

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[steve2003]

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

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[JPW]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>