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.

Please post a sample sheet with some data and expected results

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Pecoflyer,
I think I got it sorted out.
Thank you.