Complex Sort Question

[Chas]

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

 

[Mikeopolo]

Not sure how you want to use this data, but if they are already in
block, add a column to distinguish each row (eg T for total, A and
for each company), then filter the data on T to see only the tota
rows.

To turn on the filter - Data, Filter, Filter
Then a dropdown appears on all the column headings - click on the ne
column and select T.

Regards
Mik

 

[Chas]

Mike, that was a good suggestion, but the sheet this information will
be on is going to be used as a lookup table for a report page. Each
week I want to be able to sort the salesman on the page I mentioned so
I can call the information from a set cell for the report sheet. If the
auto sort option can be used for the other 2 rows, I can add additional
information to the report. I would like to keep the information grouped
together for my own use, too see where the sales for each are coming
from.

I may need to do this in 2 sheets.

Chas