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. 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) https://brickset.com/sets/10220-1 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,

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

taking (dynamic) data from the web and putting it into a cell

Thread starter ATCOBrian
Start date Sep 5, 2022

ATCOBrian

New Member

Sep 5, 2022

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.

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)

LEGO 10220: Volkswagen T1 Camper Van

An Advanced models set released in 2011.

brickset.com

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,