Go to tools, Options, custom lists.

Type into the Box the First Text?number you want to remain at the top.
then return and add in the second etc. or you can just import them.

Then click Add.

Select the Rows/Column you want to sort.

Data - Sort.

Click Options, (select sort left to right if using rows.)

Also slect the custom list you have made.

ensure the right row/colum to sort by is selected

use ascending.

Should be ok.


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=556386