Drop down list payroll

Hi all! I am totally stumped here. I am trying to make a payroll for my small logistics company. Here's my problem:
i have 15 sheets in one workbook for daily sales and attendance. a drop down list for drivers and another drop down list for helpers
Let's say i have three drivers and three helpers. (D1, D2, D3 & H1, H2, H3)
There are three routing units that can accomodate 1 driver and 1 helper to do the deliveries.
I was wondering if it is possible to compile the data (attendance & sales) of each driver & helper combo (a routing unit can consist of any combination. ex D1 and H3) at the end of the month to do a payroll.

Ex
Monday
Truck 1 Truck 2 Truck 3
D1&H1 D2&H2 D3&H3
50 30 40 (items sold)

Tues
Truck 1 Truck 2 Truck 3
D3 & H2 D1 & H3 D2 & H1
25 30 60


then at the end of the month (final sheet)

Driver 1 Driver 2 Driver 3
No. of work days = No. of work days = No. of work days =
items sold = items sold = items sold =

Helper 1 Helper 2 Helper 3
No. of work days = No. of work days = No. of work days =
items sold = items sold = items sold =


thank you!

i r excel noobcake

ack, the text didn't align properly! not only i r excel noobcake, but also a forum noobcake as well =(

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

thank you! i attached a simpler sample. the one i am working on has over 100 items. =)

help me please, help me please!

anyone? please?

A couple of questions ....

1/. Can a driver be allocated more than one truck in a day?

2/. Does the helper stay with the same driver all day?

Hi Marcol!
1. A driver can only drive 1 truck a day. Whatever truck he pocks out in the morning, that will be his vehicle for the rest of the day

2. The helper stays with the driver the whole day.

Thank you

Okay, don't have time to do much just now, look back tomorrow.