Hi all,
I have a spreadsheet of my Lego collection and I wanted to include a cell in each set's row that linked to it's current value from a website.
Is this something that GoogleSheets can do or is it an excel only job?
My spreadsheet has one lego set per row.
I'd like to "get" the NEW and USED value for each set number from the following website (the URL changes the set number at the end)
If possible, I'd like it to find the set number in column A, to work out the URL for that row.
Is it easy to do? does anyone know how it's done?
Cheers,
I have a spreadsheet of my Lego collection and I wanted to include a cell in each set's row that linked to it's current value from a website.
Is this something that GoogleSheets can do or is it an excel only job?
My spreadsheet has one lego set per row.
Lego Set | Title | Paid | Brickset Live Value (New) | Brickset Live Value (Used) |
10220 | VW Camper | £64.99 |
I'd like to "get" the NEW and USED value for each set number from the following website (the URL changes the set number at the end)
Is it easy to do? does anyone know how it's done?
Cheers,