Complicated Alphabatizing Problem - Please Help!

I need to alphabatize a excel spreadsheet by first name and last name. However, I also need the data in the other columns coresponding with the persons row to change with it as well. For example I know how to make the last and first name become alphabitized in this senerio, however it doesn't change the other two columns:

Smith, Jane $92 Filed
Smith, Kayla $07 Unfiled
Smith, Alle $12 Unfiled

So if i alphabetized this it would be:

Smith, Alle $92 Filed
Smith, Kayla $07 Unfiled
Smith, Jane $12 Unfiled

and not how I want it to be:

Smith, Alle $12 Unfiled
Smith, Kayla $07 Unfiled
Smith, Jane $92 Filed

Make sense? I have 300 pages to alphabatize so please give me the easiest way! Thanks!

You get better help if you post an Excel-example of your workbook, without confidential information.

Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

Use BEFORE/AFTER sheets if that helps make it clearer.

Make sure that when you sort the data your selection contains the columns with the 'other' data too. Then sort on first name.

Merged cells will always cause problems. If they are merged across columns for 'cosmetic' appeal, unmerge and use 'center across selection' under Cell format.

Please refer to Post # 5. You need to ensure that you select all columns including the ones that contain the 'other' data

Enjoy the forum. It always easy once you know the solution Please mark the thread as solved

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save