Create Personnel Tracker that can output Bonus to a different worksheet
I am on a project with people coming and going. I have kept track of the schedule and have it input into an Excel Worksheet. I want to find a way to take the days they have worked and tie it back into a new worksheet that will reflect the bonus they have made for each day. I am hoping I can tie it into their job title. There are a couple of Compensation kickers that I want to input as well and am hoping that there is a way to take the schedule I have, or create a more streamline one that when updated, the results will be sent to the other worksheet. I need the worksheet to be fairly detailed, but just detailed enough so that it makes sense to payroll.
|