Macro to count and filter frequencies

[EAGLEBUCKS]

Hi,
I am trying to create a macro that allows someone to copy in fault history list and allow them to just hit ctrl "a" for it to not only count how many times each error occurs but also sort the list from highest to lowest frequency.

I am getting close but I am gettting hung up on the sorting part of it. I created a macro through record a macro and did all the steps but for some reason it is not implementing the sorting part of my macro.

Anyone have any idea why this is happening? Here is my file with the macro I am using.

Thanks,
John