Getting names from a non-tabulated webpage

[bdog7]

Hi,

I'm a complete noob at this so please be patient with me. I'm trying to get names for senior lawyers and other professionals onto Excel from websites like this: https://www.dlapiper.com/en/uk/peop...5846625&sort=lastname&reload=false&scroll=258, preferably by location.

Is there a way to automate this with VBA? As far as I can make out this webpage isn't tabulated so I can't extract the data using the external data tools on Excel. Don't expect someone to write me all the code, just a few pointers/useful pages to use would be greatly appreciated.

Thanks.

bdog7

 

[pbornemeier]

Use Google to search this site for web scrape. Many results will be returned.

web scrape site:mrexcel.com