Hello,
I have a fleet of trucks and we book loads throughout the month. I have a load sheet that I currently use and I'd like to be able to track the driver/truck number's pay from each month onto another worksheet.
For example January I have 6 drivers that I choose from on the "Driver/Truck" column drop down and then enter the Load Pay amount for that load.
I'd like for that to populate from each month by driver onto the last worksheet tab "Monthly Year End Totals"
Here are some examples of the spreadsheet as well as the actual spreadsheet to work with. I hope someone can help me.
Load Sheet Example.jpg
Load Sheet Monthly Tabs.jpg
Monthly Year End Total Sheet.jpg
2015 Test Load Sheet.xlsx
Bookmarks