Macro for sort rows after value in certain column

HI I would like to have some help for below macro i need.

I need to sort the rows after customer numbers in column C4 and down.
I can sort if off course, but in this case i need it to be sorted so the ones with most same numbers come in the top and so on down.

Example.. if i have 5 with the same customer number they need to be in top if this is the highest amount of same numbers.
And under example the one with 4 of the same.

So on all the way down. I have put the sheet in here to try one. Sheet 2 have have the data

Please have a look Need a macro because its part of a bigger project.

Thanks in advance

Sincerely

Abjac

Hi Abjac,
try it

Please Login or Register  to view this content.

HI Nilan.Thanks for your answer. I tried it but it seems not to work. There was 3 numbers which was collected but i checked other and they have dublettes.
Please have a look maybe in my test sheet. Just checked more. From exactly row 100 it stop. Dont know it its important.

Thanks in advance

Sincerely

Abjac

Oops, my mistake
try again

Please Login or Register  to view this content.

Hi Nilem.

This one did the trick now. Great really thanks allot .

A big help for what i am doing now.

Sincerely

Abjac