Hi Rafi,
I think recording a macro would answer your question.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rafi" wrote in message ...
I have an Excel worksheet that requires two custome sorts one being the
primary key and the other the secondary.

The first sort key is Columa "A" and the second sort key is column "D".
Column A is the primary key and it has to be sorted by OrderCustom=4 and
column "D" is the secondary key and has to be sorted by OrderCustome = 7

Your help is much appreciated.