Need to get the data from Website. Target website url and required fields are enclosed in attach file.
Requirement is to use VBA/Excel.
Once after getting the data we will have website URLs. Using those URLs we want to run the spider to get email addresses from their websites. Second task can be done using any language of your choice. You can even take readily available python scripts from Github and modify it for us. We are fine with that.