Position active cell in upper left corner of the data block.

Menu, Data, Sort, set first key to 'organization' column, set second

key to 'grade' column. Click OK.

If you want the specific VBA for this, you can record the process as a

macro and get the specifices of the sorting method.

I hope this was what you meant! <g>

Ray <><

------------------------------

This email is intended for the use of the individual or entity to which

it is addressed and may contain information that is privileged,

confidential and exempt from disclosure under applicable law. If the

reader of this email message is not the intended recipient, or the

employee or agent responsible for delivery of the message to the

intended recipient, you are hereby notified that any dissemination,

distribution or copying of this communication is prohibited. If you

have received this email in error, please notify us immediately by

telephone at (502) 695-6870 or (888) 749-5799 and also indicate the

sender's name. Thank you.

>>> Stephen.Wolfe@macdill.af.mil 3/3/2005 10:56:14 AM >>>

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

[excessive quoting removed by server]