You may want to look at building a Pivot Table.
From the view of your sorted table I think this will work for you.
If your not familiar with them press F1 and enter "pivot table" in the seach
box.

Best regards,
Dave

"Acanesfan" wrote in message
...
I am using Excel 2007. I need to sort by job no and client no. Some
clients
have more than one no. Here is an unsorted list:

Mgr Client No Client Job No Inv # Inv Total
Carol 455 Bannon 4123 1006466 28,754.30
Bob 455 Bannon 4123 1006487 4,410.00
Bob 455 Bannon 4123 1006640 4,410.00
Carol 477 Dove 1245 1269841 13,971.80
Sandy 477 Dove 4587 1258002 3,492.95
Paul 494 Bannon 6546 1006487 6,363.17
Carol 494 Bannon 6544 1006390 931.45
Paul 494 Bannon 6545 1006466 6,520.17
Paul 839 Carolina 6789 1006713 6,985.90

And here it is sorted. .

Mgr Client No Client Job No Inv # Inv Total
Carol 455 Bannon 4123 1006466 28,754.30
Bob 455 Bannon 4123 1006487 4,410.00
Bob 455 Bannon 4123 1006640 4,410.00
4123 Total 37,574.30
455 Total 37,574.30
Carol 477 Dove 1245 1269841 13,971.80
1245 Total 13,971.80
Sandy 477 Dove 4587 1258002 3,492.95
4587 Total 3,492.95
477 Total 17,464.75
Paul 494 Bannon 6546 1006487 6,363.17
6546 Total 6,363.17
Carol 494 Bannon 6544 1006390 931.45
6544 Total 931.45
Paul 494 Bannon 6545 1006466 6,520.17
6545 Total 6,520.17
494 Total 13,814.80
Paul 839 Carolina 6789 1006713 6,985.90
6789 Total 6,985.90
839 Total 6,985.90
Grand Total 75,839.75

Is there a way that I can have the client name show next to the subtotal
automatically? The spreadsheet is actually much larger than shown, and
entering the names manually is very time-consuming. Any solutions would
be
appreciated. Thank you.