the reason im doing all this is because as a driver myself i want to know exactly what im gonna get paid, because if the office makes a mistake with the wage i will know exactly how much they have short changed me by.

as for making the Setup sheet being very hidden i will be doing that before giving out this workbook to other drivers.

however i still need help on this worksheet please

May I suggest that your project will be easier to code if you use the Annual sheet to record all the information found on both it and the pay sheets on a worked day by worked day basis. The code can fill in the missed dates with "Day Off" on the pay sheets. Do not place any formulas on the sheets, let code do the work.


i would like to see your suggestion on this as i really dont know what you mean