This may be very simple for some of you but I have a very advanced customer tracking and employee commission payroll spreadsheet I would love your assistance with. In fact, it is so elaborate I would be delighted to pay somebody to help me complete it.
First, I want the salesperson to enter their initials, their customer information, and the sales amount on each row of the main worksheet. Then I would like excel to transfer the sum of all their customer commission percentages to the second page. It is for a door-to-door pest control sales company.
Attached is the file spreadsheet without the fancy formulas. Row 6 of each worksheet is a rough explanation of what I need.
THANK YOU!
Bookmarks