Hi there,

I want to create a worksheet whereby I can copy and paste a website URL into a cell, and automatically scrape a few bits of information from the website page and display them next to the URL cell. I want to be able to do this for multiple URLs on the same page. Each URL will link to a car advert on a classified ad website, so the required information elements will be in the same place for each URL. Consider the example:

| | A | B | C |
| 1 | Pasted URL | Make | Model |
| 2 | Pasted URL | Make | Model |
| 3 | Pasted URL | Make | Model |


Hopefully that makes sense. I just want to be able to paste in the ad url and then excel to populate the adjacent 2 cells with information elements scraped from the url.

Can anyone help?

Cheers