View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_7_] Jon Peltier[_7_] is offline
external usenet poster
 
Posts: 115
Default Conditional move rows to another sheet

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