Need macro to extract data from google

[nethmi fernandiz]

Hello,

Is it possible to extract the address and phone number from google using macro?

I have excel where, column A has company name, column B has company location and we need company address in column C and company phone number in column D.

How to do? Please help

PFB table for reference

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Company name[/TD]
[TD]Company location[/TD]
[TD]Company address[/TD]
[TD]Company contact number[/TD]
[/TR]
[TR]
[TD]IBM[/TD]
[TD]London, UK[/TD]
[TD]Data needed[/TD]
[TD]Data needed[/TD]
[/TR]
[TR]
[TD]Thrive Global[/TD]
[TD]New york, USA[/TD]
[TD]Data needed[/TD]
[TD]Data needed[/TD]
[/TR]
</tbody>[/TABLE]








Thanks in advance
Namrata