How to Sort or move list of preferred names

Hi all,

My question is simple one i guess but yet tricky

I have two headers, "Ref no" and "Names"

I always need list of names "A" and "B" should go to middle portion of entire data. Names can duplicate.

So all of A's or B's should be moved to the middle of entire data in the sheet.

For example, The total records is 12 Then whatever the list i say like "A" and "B" data should moved to the middle of those 12 rows.
So the desired result is "A" and "B" data are moved to the middle of the entire set of data. Somewhere after 6th row.




Attached sample file.

Hi akuini,

I have a question, now as said criteria being "A" and "B" is fine. This code works as intended.

What if i have criteria, listed in the range "J5:J20"?. How that can be updated...? instead of just two criteria.

Thanks Akuini, this helped.