Sorting issue
 

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

Sorting issue
 

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