Searching web and retrieving phone numbers

Raven31

New Member
Joined
Feb 11, 2014
Messages
17
Good Afternoon,
I have spent the better part of today searching the site for the answer to my need. We are Data Scrubbing for a software conversion and using Excel 2010 to do so. I have a spreadsheet of over 90k company names, addresses, FEINs, and telephone numbers.

There are over 8000 phone numbers and web addresses missing that need to be added to the sheet :eeek: and I am hoping to be able to do so without searching the web individually for each phone number. I thought there may be a macro or lookup or something that will tell Excel to search the web (perhaps a specific site like The Blue Book, The Yellow pages, or a search on the company name)and retrieve these phone numbers and put them in the specific cell they need to be in.

The company names are all in the same column as well as the items that I need to fill in if they are missing such as the area code, phone number, and web address.

Any help you can provide would be so helpful!!

Example:
[TABLE="width: 700"]
<tbody>[TR]
[TD="align: center"]Vendor #[/TD]
[TD="align: center"]Customer Name [/TD]
[TD="align: center"]Addr 1[/TD]
[TD="align: center"]City[/TD]
[TD="align: center"]State[/TD]
[TD="align: center"]Zip[/TD]
[TD="align: center"]Area Code[/TD]
[TD="align: center"] Phone[/TD]
[TD="align: center"] Website[/TD]
[TD="align: center"] FEIN [/TD]
[/TR]
[TR]
[TD]A1001[/TD]
[TD]ABC Construction Co, Inc.[/TD]
[TD]1234 Main St [/TD]
[TD]Baltimore[/TD]
[TD]MD[/TD]
[TD]21222[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]52-4017854[/TD]
[/TR]
[TR]
[TD]A1002[/TD]
[TD]Apple Contruction Co[/TD]
[TD]4589 Maple Ave[/TD]
[TD]****eysville[/TD]
[TD]MD[/TD]
[TD]21093[/TD]
[TD]410[/TD]
[TD]5556666[/TD]
[TD]www.gensis.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A1003[/TD]
[TD]Arc Water Supply[/TD]
[TD]1515 Cold Point Lane[/TD]
[TD]Brewer Hill[/TD]
[TD]CT[/TD]
[TD]41096[/TD]
[TD][/TD]
[TD][/TD]
[TD]www.arc.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B1001[/TD]
[TD]Baltimore Sign Co[/TD]
[TD]15 EAst Lane[/TD]
[TD]Sinful[/TD]
[TD]NJ[/TD]
[TD]06190[/TD]
[TD]609[/TD]
[TD]7775621[/TD]
[TD][/TD]
[TD]21-4258978[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,225,477
Messages
6,185,221
Members
453,283
Latest member
Shortm88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top