You can...
From Tools | Options | Custom Lists
Create your own list.

Select your range.

The from Data | Sort | Options... select your new list from the First Key
Sort Order dropdown.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Vinny" wrote in message
...
Is there a way that when I go to datasort and choose a particular column
to
sort by (in my case column E) It will sort using my own instructions?
(ie. I
want to be able to sort non-alphabetically, but by a predefined order).
It would also be nice to use this whether it is the 1st, 2nd or 3rd option
for sorting.

Thanks
Vinny