Need a formula/macro code

[Bhugz]

Hi guys and girls.

I need your help with coming up with a macro code/formula for spreadsheets that I work on.

The spreadsheets I work on contain addresses of subscribers eg:
3462768 HASTINGS 4122
3504288 LOWER HUTT 5011
3568930 NELSON 7010
3566770 PAHIATUA 4910
3374483 PALMERSTON NORTH 4440
3566639 PORIRUA 5022
3389927 WAIKANAE 5036
3396769 WANGANUI 4500
3402104 WANGANUI 4574
3391879 WELLINGTON 6011
3420838 WELLINGTON 6011
3422600 WELLINGTON 6012
3570097 WELLINGTON 6012
3445211 WELLINGTON 6022
3386860 WELLINGTON 6022

What I want to be able to do is automatically with the use of a macro code categorise the different cities and suburbs to one of 9 regional areas (Wellington, Hutt Valley, Porirua, Kapiti, Wairarapa, Manawatu, Taranaki, Hawkes Bay and Other).

How would I go about doing this? I know I would need to use if statements but i'm just not sure about how to do the macro code for this.


Thanks.

 

[Sektor]

I guess you need to extract area into adjacent column, select your data with that column and sort it

 

[Bhugz]

As I'll be working on multiple spreadsheets going through months of data that is not ideal as there will be thousands of lines

 

[Sektor]

But you have no other way to get them sorted 'cause areas are among other text.