ChrisFoster
Active Member
- Joined
- Jun 21, 2019
- Messages
- 251
- Office Version
- 365
- Platform
- Windows
Hi all,
I have a list of ICO Registration numbers in column E on a worksheet.
Using Information Commissioner's Office - Register of data protection fee payers I can search for individual reference numbers and it provides information on that company such as address, contact details and the expiry date of the license/registration.
Using reference Z5347709 as an example, once the search button is pressed it takes me to URL Information Commissioner's Office - Register of data protection fee payers - Entry details - so basically
and then the reference I am searching for.
What formula can I use to extract the date next to 'Registration expires:' on each reference number in column E rather than me having to manually search for each one?
Regards,
Chris
I have a list of ICO Registration numbers in column E on a worksheet.
Using Information Commissioner's Office - Register of data protection fee payers I can search for individual reference numbers and it provides information on that company such as address, contact details and the expiry date of the license/registration.
Using reference Z5347709 as an example, once the search button is pressed it takes me to URL Information Commissioner's Office - Register of data protection fee payers - Entry details - so basically
Excel Formula:
https://ico.org.uk/ESDWebPages/Entry/
What formula can I use to extract the date next to 'Registration expires:' on each reference number in column E rather than me having to manually search for each one?
Regards,
Chris