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