Jump to content
Please Use CODE Tags

Look up mailing address based on business name (using Excel)

Scrim Snacks
 Share
Posted

Typical task for me: I have a list of names of 50 local businesses and I need to find out their mailing address. I usually google them manually and copy/paste their address into my excel file.

 

There's got to be a better way. My research shows several ways including google places api, vba code, excel power query. But the info is overwhelming and I'm not really smart enough to know what most of it means...

 

My skill level is I can copy/paste VBA code and create various macro functions in excel.

 

Any insight would be great. I'm willing to do my own research, just need to go down the right path, and not 100 dead ends based on my coding skill level.

 

Thanks,

 

Scrim Snacks

 

 

Link to comment
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programming

×