Data - Regions

Hi There This project involves adding data from a website into the attached xcel sheet. Basically, it is to search the town name on the website and the xcel sheet and add in the region name in Column K. For example to complete NSW go to the website [login to view URL] NSW has 6 regions: Central Coast (this has been completed) Hunter Valley North Coast Regional NSW South Coast Sydney (this has been completed) Click on each of the regions and you'll see which towns belong to which regions. The town in the xcel sheet needs to mapped to the region. For example, if you click on Central Coast (twice) these towns will appear: Alison, Alison, Avoca Beach, Bandon Grove, Bateau Bay, Bay Village, Bendolba, Bensville, Berkeley Vale, Blackwall, Blue Bay, Blue Haven, Booker Bay, Bouddi, Box Head, Brookfield, Brownmore, Bucketty, Budgewoi, Budgewoi Peninsula, Buff Point, Bushells Ridge, Calga, etc. The task is to search 'Alison' (the town) in the xcel sheet and in Column K write the word Central Coast (this represents the Region). The following Australia states need to be completed: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] Make sure that the region and town are from the correct state. Column C represents the state, for example, NT, NSW, VIC, QLD, TAS, WA. Please delete any data in Column J that says Post Offices Boxes and LVR. You only need to map the region for Delivery Area. Erin