Hi there ,

I need to sort a worksheet based on a specifct criteria, on a
collumn,
based on collumn A , DVD then MD them CD.

Like this:

Original
A B C
CD 10 xx
CD 10 xx
DVD 10 xx
CD 10 xx
DVD 10 xx
MD 10 xx
CD 10 xx
MD 10 xx
CD 10 xx

After
A B C

DVD 10 xx
DVD 10 xx
MD 10 xx
MD 10 xx
CD 10 xx
CD 10 xx
CD 10 xx
CD 10 xx
CD 10 xx

Regards