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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separate report on tabs based on Sales Rep Info
Maybe this for creating separate sheets:
http://www.rondebruin.nl/copy5.htm Maybe this for the conversion to .PDF: https://online.primopdf.com/Default.aspx Finally, you may have a .PDF Printer installed already; check he http://www.print-driver.com/howto/co...el_to_pdf.html HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "LizaJane" wrote: 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 |
Reply |
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) |