Sorting issue

[evertonk]

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

 

[Nigel]

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.

 

[evertonk]

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
(e-mail address removed)

Tks a Lot worked perfectly in my vba code.

Best regards