Tools / Sort / by column ?, and then by column ?

Or programmatically :-

o.Range("a1:c13").Sort(o.Range("a2"), 1)

(Easiest way to find out is to record a macro in excel and do what you

want - then look at the macro)

HTH,

Robbo.

-----Original Message-----

From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com]

On Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI

Sent: 03 March 2005 15:56

To: profoxtech@leafe.com

Subject: [NF] -- Excel sorting question

For those who are Excel gurus ...

I have a user that has a simple 7 column spreadsheet, nothing fancy and

that individual Wants to have the spreadsheet maintain a two level sort.

The first level on the 'organization' Column and the second level on the

'grade' column.

How do you do that?

TIA

v/r

//SIGNED//

Stephen S. Wolfe, GS-11, DAFC

Data Services Manager

(813) 827-9972 DSN 651-9972

OT-free version of this list:

http://leafe.com/mailman/listinfo/profoxtech

** All postings, unless explicitly stated otherwise, are the opinions of

the author, and do not constitute legal or medical advice. This

statement is added to the messages for those lawyers who are too stupid

to see the obvious.

______________________________________________________________________

This email has been scanned by the MessageLabs Email Security System.

For more information please visit http://www.messagelabs.com/email

______________________________________________________________________

______________________________________________________________________

This email has been scanned by the MessageLabs Email Security System.

For more information please visit http://www.messagelabs.com/email

______________________________________________________________________