VB or Macro? Advice on best route to creating web search data returns

I am trying to use a macro to return further registration information from http://www.lawsociety.org.uk/find-a-...search#formtop to enable me to add data points to a database of current UK lawyers.

There appear to be a few ways to do so and I would like to know your thoughts on which will be most fruitful - 1) record a macro - import complete webpage and then select relevant data; copy and paste into table. 2) inspect the element of the search on the webpage and go direct to the information stored in the coding; this is then returned straight into excel with no import required (I've seen this done on a youtube clip and appears to be the slickest way) - this requires VB coding and not macros - so I have struggled thus far. 3) AN Other way - any ideas?

In essence, I have a list of forenames and surnames and I would like to use excel to match these up to company and searchable databases on the internet, to dramatically expand my database. I am searching around 100k names so this is an enormous time saver.

Happy to post further details on the project if it helps

Best

Harry

Morning, are you still looking at this?

Can you post a sample of what you want the data to look like once returned and the structure of the data you already have?