Mechanically or manually?

For the latter ...

Sort by Column A, Column B
Data==Filter=Autofilter
Filter by Sales person
Copy/paste to Sales Person sheet

Repeat for all Sales persons


"MEAD5432" wrote:

I want to sort my data and filter it into new worksheets based on the
information from one column.
Example:
Column A is sales person
Column B is customer name
Columns C:G is customer information (address, etc...)

I want to sort the data by sales person into separate worksheets that I can
give to the sales person.

Hope that makes sense.