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.

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.

recording a macro will not do since a custom sort can only function as the
Primary sort key.

Thanks

"Rafi" wrote:

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.

How about just doing multiple single key sorts. Start with the secondary key,
then sort by the primary key.



Rafi wrote:

recording a macro will not do since a custom sort can only function as the
Primary sort key.

Thanks

"Rafi" wrote:

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.

--

Dave Peterson