On [url removed, login to view] in the UK there are currently 191 companies listed under the category of Export packers in England. Copying and pasting the following url into your browser will take you to the search results.
[url removed, login to view]+packers&location=England&scrambleSeed=18356068&ssm=1&lastKeyword=export+packers&intCam=intToolbar&selectedClassification=EXPORT+PACKERS&searchType=refinedclassification
I want all companies with their postal address and telephone number entered on to an excel database. The column headers will be company name, address 1, address 2, address 3, address 4, address 5, post code, telephone number.
As the website will only display 100 results at a time, you will need to click through on to the different locations, found on the right of the page, to access the full list of results:
• North East England
• North West England
• South East England
• South West England
• East Anglia
• Yorks and Humberside
• Thames Valley
I would like each location entered into a separate worksheet on the Excel file. An example excel file is attached showing the column headers and the different worksheets.