View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LizaJane LizaJane is offline
external usenet poster
 
Posts: 2
Default 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