Sort post code prefix into north and south using COMMAND BUTTON

[charliew]

Hello everyone,

I have a question that i'm not sure can be done so thought i would ask the experts.

A bit of context, i am working with my transport manager to aid him splitting his jobs into north and south of the country so he can schedule that accordingly...a report will be exported off our CRM and from there the data manipulated slightly.

I have a list of post code prefixes already in North/South column in a separate sheet and i've extracted the prefix from the main data set in a helper column.

What i had imagined is a command button that once clicked will sort the data and put all north postcodes highlighted blue (for example) at the top, and the south highlighted yellow underneath...

I've had a bit of a play with range.sort but it just wont do it...and i can't figure out how to get it to sort all the columns and not just the one with the postcode in it.

Any help is greatly appreciated.

Thank you

 

[Fluff]

Can you post a sample of your data along with some of the prefixes you have on the other sheet.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.