Could someone please help me with the following:
We have lots of vehicles and need to keep the "Road Tax Due Date" and "MOT Expiry Date" updated.
This information is available from the site https://www.vehicleenquiry.service.gov.uk/
The parameters required are Vehicle Registration Number and Vehicle Make. These details are there in my excel worksheet.
How can I automate the updating of the "Road Tax due date" and the "MOT expiry date" to the respective vehicle in my excel list instead of manually browsing to the website, updating the form and copying and pasting the results to my excel sheet.
Automating this will save me a load of time and make it highly accurate.