I have a sorting problem. I have attached a copy of the excel file (Excel 2010, Windows 7).



The name of the person needs to be sorted alphabetically.

For example, information about Jones (A1) is located A2, A3, A4, A5, A6, and A7 through Z2, Z3, Z4, Z5, Z6, and Z7. For example, for Jones, in B2 he paid $1. in C5 he paid $6, in X3 he paid $12.00, and so on.

The Grand Total paid in in Y1

Then, starting in A9, we start the exact same again with Mr. Anderson, with the next 6 rows dedicated to him (A9 through A15 continuing through Z through Z15.

Now, I want to put Mr. Anderson and ALL his information above Joone's information, as a sort.

THANKING YOU IN ADVANCE.

My email is nathan_strahl@yahoo.com

Attached Files

practice1.xlsx (10.8 KB, 19 views)