Sort on Specific Name

[The Animal]

Hi
I have a "Sort Selection" B3:M27.
In cells F3:F27 there are numerous names and for example one is "Janette" and in Cells H3:F27 there be the same name "Janette" once again with numerous other names
In the corresponding F cell or the H cells there could be other names.
I need a macro that will sort "Janette" to the top of the "F" column as the first sort option and then if "Janette" appears in the "H" Column have that as the second sort.
So if the name is found in 4 places in column F then all the Janettes will sort to appear in rows 3,4,5,6 and if the name appears 3 times in column H then they will sort to rows 7,8,9.
Any of the remaining names that are not "Janette" can sort alphabetically on column F.
I have tried sorts using A to Z and custom sorts but do not seem to get all the "Janettes" to sort to the top of column F and all the "Janettes" in column H to appear consecutively.
Any help would be appreciated.
Stephen

 

[LloydFinancials]

I am able to get custom sort to work. I would have to see an example of your data where it is not working and what it would look like after the sort.

 

[The Animal]

Thanks so much
]

 

[The Animal]

Sorry pushed "Post"
Thanks again

F G H I
Janette SO Entry
Janette Invoicing
Janette SO Entry
Brad Delivery Janette
Joey Picking Janette Packing
Joseph Picking Marty Packing

 

[LloydFinancials]

I am not sure what columns have what data, and you did not post what the results would look like after.

You can go to this link to download an HTML maker or you can upload your file through Google Docs or any number of free FTPs.

http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html