Hi Gord,

Thanks for the quick reply but after I enter some text in Col C and
press enter key, nothing really happens, only Col C and Col D is
highlighted but none sorted.

I pasted the code in the sheet tab, view code.

The data actually begins on Row5 so I tried changing the A2 to A5 and
C2 to C5.

Any help is appreciated. Thanks again.