I have a worksheet that has 10 salesmen listed. For each person there
are 3 rows of information. The 1st row is total overall sales. The 2nd
row is sales for one company and the 3rd row is for another company.
Each row contains a breakdown of various information that is being
looked up on other sheets. What I would like to do is sort 1st by total
sales putting that salesman at the top of the list but leave the other
2 rows with the first.

Here is an example:
(using 8 columns of lookup data. Last one is total sales and using it
to sort)

Row 1 - person A total sales
Row 2 - person A sales for company A
Row 3 - person A sales for company B

Row 4 - person B total sales
Row 5 - person B sales for company A
Row 6 - person B sales for company B

Row 7 - person C total sales
Row 8 - person C sales for company A
Row 9 - person C sales for company B

Repeats for all 10 people.

Is it possible to link or lock some how all three of them together? If
so my next question is going to be if it is possible to automatically
sort the other 2 rows to always put the highest company first. I have
not had a need to use macros but I would be willing to try anything at
this point.

Thanks in advance,

Chas