Please let me know how to sort that it pick and gives the required list first and then sorts others. Eg from the list of ab,bc,cd,de,ef,fg,gh etc. It want cd and ef to come at the top (sorting order) and the rest to be sorted.

Move that particular row to the top and don't include it in the sort. "So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown

I see you used the word "macro" in your subject, so I am assuming you want to do this with code, as opposed to manually moving the data around. If that's the case, it can be done, but I think we need a little more detail. How would the code know what's in the "required list", in this case cd and ef? In concept the code could be something like this: 1 - Search the big list for each item in the required list. 2 - Cut/Insert Paste each item to the top of the list. 3 - Select the items in the required list and sort them. 4 - Select the rest of the list and sort it. The actual code would depend on how you are passing the required list to the macro.