Sorting with vba, custom sort?

Hi all,

I am trying to sort a table in excel, I have the following code so far:

Please Login or Register  to view this content.

I know it can be done by key1, key2 and key3 but I did it this way in case I have to add more columns to sort by. I know it would be simple to do without vba, but would like to learn to do it this way.

So this code works all fine for now, but I would like to add a custom sorting order for the basket size sort. I have lots of basket sizes, I don't know the name of them, but I have ones that start with 05 and I would like those ones to be the first ones for each First name Family name combo.

I couldn't get it to work in normal excel sort either with the "05*" so I'm not sure how to do this..

Please help?