ELISABETH0710
New Member
- Joined
- Jun 25, 2008
- Messages
- 1
I have a main worksheet that holds all salesperson commissions. I want to create individual salesperson reports that will automatically populate all of the same information from the main worksheet. The purpose is to give each salesperson their own commission report, but not leave room for errors in copying and pasting from the main worksheet.
Present main sheet is set up with the following columns:
CUST. NO,CUSTOMER NAME,SALES ORDER DATE,COMM PAY DATE,SLS # SALESPERSON NAME,BEG COMM %,ORDER AFTER 5/7 Y/N,SON,OM/GSA,C.C. Y/N,SALES AMOUNT,SALES TAX,CUSTOMER FREIGHT,TOTAL INVOICE,PO COST,INVOICED COST,FREIGHT,CC FEE,GSA FEE,TOTAL COST,NET PROFIT,NET MARGIN %,EFFECTIVE COMM %,GROSS COMM.,COMM. TO BE PAID
All of the same columns would need to be present in each individual salesperson sheet.
Each row in the worksheet represents a different sales order to pay commissions on.
I am using Excel 2004 for Mac. I would appreciate any suggestions!
Thanks!
Present main sheet is set up with the following columns:
CUST. NO,CUSTOMER NAME,SALES ORDER DATE,COMM PAY DATE,SLS # SALESPERSON NAME,BEG COMM %,ORDER AFTER 5/7 Y/N,SON,OM/GSA,C.C. Y/N,SALES AMOUNT,SALES TAX,CUSTOMER FREIGHT,TOTAL INVOICE,PO COST,INVOICED COST,FREIGHT,CC FEE,GSA FEE,TOTAL COST,NET PROFIT,NET MARGIN %,EFFECTIVE COMM %,GROSS COMM.,COMM. TO BE PAID
All of the same columns would need to be present in each individual salesperson sheet.
Each row in the worksheet represents a different sales order to pay commissions on.
I am using Excel 2004 for Mac. I would appreciate any suggestions!
Thanks!