[RESOLVED] NEW QUESTION Excel -- Sort Multiple columns

[kfcSmitty]

See post #9





Is it possible to sort by multiple by multiple columns in excel?


IE)

Oper Unit	Dept	Program Code	Account	Name		Staff ID	Start Date	End Date	Amount		Subtotals
									
03		05	11003		40100	Doe, John	00000000	4/1/2005	3/31/2006	40,000.00	
03		05	11003		42000	Smith, Leo	00000001	4/1/2005	8/31/2005	40,000.00	80,000.00
03		05	11003		42000	Doe, Jane	00000002	4/1/2005	3/31/2006	40,000.00	
03		05	11003		42000	Smith, Sam	00000003	4/1/2005	3/31/2006	40,000.00	80,000.00
03		05	11006		40100	Wayne, Adam	E8587900	4/1/2005	3/31/2006	40,000.00	
03		05	11006		40100	Welch, Robert	75899079	4/1/2005	3/31/2006	40,000.00	80,000.00
04		02	80000		42000	Doe, Pat	H8KK5970	4/1/2005	3/31/2006	40,000.00	40,000.00
04		05	90400		42000	Smith, Tom	etc		4/1/2005	3/31/2006	40,000.00	40,000.00
04		06	01000		40100	Smith, Alex	etc		4/1/2005	3/31/2006	40,000.00	40,000.00
04		06	01000		42000	Smith, Leo	etc		9/1/2005	3/31/2006	40,000.00	40,000.00
05		13	13003		42500	Allan, Patricia	etc		4/1/2005	3/31/2006	40,000.00	40,000.00
05		14	02004		42000	Adams, John	etc		4/1/2005	3/31/2006	40,000.00	40,000.00

I need to sory by Operating unit first.

Then within each Operating Unit I need to have the department, the program code and the account sorted. And each time any of them change, I have to have a subtotal on the far right...


I have NO idea where to start with this since I rarely use Excel.

also, I am trying to print this report from Access...so all Excel options may not be available to me...