Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated task to present data in a graph form. | Charts and Charting in Excel | |||
Automated task to present data in a graph form. | Charts and Charting in Excel | |||
Division by zero in automated subtotals | Excel Discussion (Misc queries) | |||
Excel as a reporting tool | Excel Discussion (Misc queries) | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions |