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 BS3 BS4 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?
Thanks.
Bookmarks