rightmove.co.uk selected data scraped to excel spreadsheet or csv (python or VBA script?)

I have a list of 2,900 UK postcodes on an excel spreadsheet. I am looking for a script (can be python, or VBA (preferred) or any other language) that would scrape selected texts/fields from the rightmove.co.uk website listing (particularly house sold prices, and rental listing) and paste thgese into the subsequent columns of the spreadsheet.