You could use a filter or autofilter to exclude all but the particular
salesperson, and copy the filtered list to another sheet. Repeat for
each person, or write a macro to do this for you.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

J wrote:

This is like a dispatch thing we've been concocting. Basically there
are some ten to twenty orders per day that need to be given to
employees. We'd like one sheet that's sort of the summary that has the
data across 10 columns or so. On that sheet we'd assign employees to
each order by entering their name next to the order. Say in column
one, we'd put each employee's name. We'd like to have each employee's
row copied and put onto another sheet. The destination cells would be
important since we've made a little schedule thing that prints stuff
like -- "Name:" & custName (or A:2) or something. Know what I mean?