Automated Reporting
 

Each rep has a commission spreadsheet that they submit to me twice a month.
For 2006, I've set up a single shet where they enter the details of all their
orders. There are columns for Date, Type, Quantity, etc. I would like to have
multiple worksheets that automatically include the details of each column
between two dates. I know I can do this with data filters but I would like to
have each report created automatically with each new order I know pivot table
will also work but I'm still looking for something else.
--
JerryS