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?

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?

Jon Peltier wrote in message ...
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.


OK. Can you suggest a tutorial site that helps with some of the
macro writing? Like: how to reference a cell, or a range of cells, in
VBA for instance.

Thanks

In conjunction with using the macro recorder, and the object browser
within the VB Editor, you could check out Chip Pearson's site
(http://cpearson.com) which is a very comprehensive source for VBA help.

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

J wrote:

Jon Peltier wrote in message ...

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.



OK. Can you suggest a tutorial site that helps with some of the
macro writing? Like: how to reference a cell, or a range of cells, in
VBA for instance.

Thanks