| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separate report on tabs based on Sales Rep Info
I am needing to take a large data population and create a report based on the
Sales Rep/Customer combination. I need each repset(combination) on a new tab and then I need to pdf it. I am including a sample of the layout. Please help as I need to do this ASAP. Thanks. Lisa Walt Chittum 16 Lost, New and Popular Item Opportunties Knoxville Zoo Cust # 207915 LOST = Items Purchased Two or More Times in July - Dec 08, But Not In Jan-May 09 Item # Description July-Dec 2008 Purchases of Item # Events Average Unit Price Most Recent Purchase Date Most Recent Purchase Unit Price Price Level System Price Average Unit Price 12 Mos Data NEW = Items Purchased in 2009, Not in 2008 (See if item lost above has been replaced) Item # Description Jan thru May 2009 Purchases of Item # Events Average Unit Price Most Recent Purchase Date Unit Price POPULAR = Top 10 Items on Most Popular Item List Not Purchased by Customer Item # Description System Price Kelsan Avg Unit Price |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sales report | Excel Discussion (Misc queries) | |||
| Pull info from separate worksheet based on given criteria | Excel Discussion (Misc queries) | |||
| Sales Report | Excel Worksheet Functions | |||
| Calculating sales commission that changes based on a sales volume | Excel Worksheet Functions | |||
| Add Sales Goals to Sales Report in Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
