Hopefully someone can help me.
I'm trying to fetch data from a website that will change with every row (a particular cell value in that row appended to the end of the URL).
It's for a Lego Set database; looks like this;
The wesbite I'm trying to get the data from is: LEGO 10220: Volkswagen T1 Camper Van
In this case, the final part of the URL is "10220" (could be taken from Cell A2). the numbers in red would be fetched from that URL.
I'd like it to fetch the "current value" fields from the dark table on the right hand side of that website (both new and used values).
I'd like it to then fetch this data for each row (each row being a new Lego set number).
Is this something that's easy to do?
I've tried but given up in the hope someone more clever can do it easier than I can.
Any help appreciated.
I'm trying to fetch data from a website that will change with every row (a particular cell value in that row appended to the end of the URL).
It's for a Lego Set database; looks like this;
| A | B | C | D | E | |
| 1 | CODE | TITLE | COST | BRICKSET VALUE (USED) | BRICKSET VALUE (NEW) |
| 2 | 10220 | VW Camper | £34.99 | £78 | £109 |
The wesbite I'm trying to get the data from is: LEGO 10220: Volkswagen T1 Camper Van
In this case, the final part of the URL is "10220" (could be taken from Cell A2). the numbers in red would be fetched from that URL.
I'd like it to fetch the "current value" fields from the dark table on the right hand side of that website (both new and used values).
I'd like it to then fetch this data for each row (each row being a new Lego set number).
Is this something that's easy to do?
I've tried but given up in the hope someone more clever can do it easier than I can.
Any help appreciated.
