Hello there VBA experts,

I have a list of faults and each fault has a specific fault code e.g. Hardware failure = fault code 101

There are only a set amount of fault codes in the data I extracted roughly around 10. What I would like to do is organise the data based on the fault code and highlight the whole row red for the fault code that appears the most times. So if fault 101 appeared the most times that month the data would be organised with all fault 101's at the top and then decline with the fault codes that appear less and less. I think it would be pretty cool if the data could be organised like this with the most popular faults highlighted in red at the top and then correspond down to the faults that maybe have one occurance and highlight them in green or amber etc.

Any tips or starting points with this VBA macro would be most welcomed !

Thanks

HB