VBA for UK Postcodes

Hi,

I have a huge list of data that I need to split into separate postcode areas.

For example...

Phone Number - First Name - Last Name - Address - Postcode

I want to split each postcode area into a different file. BS1 BS2 BS11 BS12 and so on. However, some of the postcodes are in different formats so one might be BS1 1AA and another could be B1 1AA. When I select the postcodes to move to another sheet the other data on the same row has to move as well to stay relevant.

Is there any easier way for me to do this other than manually selecting each area then copy and pasting?

Example Data - I want each of these to go into its own spreadsheet, BS15, BS4, BS19. But there may be 3000 rows of data in BS15 for example.

Phone First Name Last Name Add1 Add2 Add3 Postcode
1234567891 J Smith 100 Scott Street Bristol BS15 4RT
2345678910 S Thomson 114 Stable Drive Bristol BS4 9QV
3456789101 M Jackson 17 Maple Avenue Bristol BS19 5HU



Thanks.

I thought this forum would be more appropriate to my question and this was also suggested by another poster on the other thread.

I have attached a pretty standard data set that i would be working with, albeit on a much larger scale.

Apologies I misread what you wrote.

Well we are all here now anyway

There have been three posts in the other thread this evening - stop wasting people's time by creating duplicate threads.

Pete