I have looked for a solution to this but can't find one so apologies if I missed something somewhere.
I am starting with a list at:
Register of Approved Contractors - Security Industry Authority
This page has a list of around 550 companies
Clicking on the company name triggers a JavaScript link to a second page giving more details about the company (again in a table format)
I wish to capture the 'more details' into a spreadsheet and then loop to the next record in the main list, link to the 'more details' for this company, save these to my spreadsheet then keep looping this process until 'more details' for all 550 companies are added to my spreadsheet.
I am new to AA so any help would be much appreciated