Create a custom list DVD,MD,CD using Tools-Options-Custom List

Then when you sort select column then choose options and select the custom
list just created.

--

Regards,
Nigel




wrote in message
...
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