Hi,
I inherited an hours worked and holidays earned/taken spreadsheet from a colleague at work.
I've managed to make it work correctly however it's very cumbersom and not very user friendly.
I did manage to make a User Form to add new employees however that was after hours of scouring the internet for help and using very basic VBA of which I have little or no knowledge.
I'm hoping someone would be able to take a look and help me out with streamlining it.
If this isn't the done thing here, let me know and I'll struggle on with what I have
Basic requirements of the excel document:
Have a summary sheet where you can view each employees:
- total holidays carried over from previous year
- total days worked for current year
- total days paid for current year
- total holidays owed for current year
- total holiday days earned for current year
- total holidays recouped in current year
- bank holidays eligable for in current year
- total holidays remaining for current year
Then for each week, I need to be able to fill in whether the employee has worked each day and whether they have been paid for that day (we operate a system where you can extra days you work and then take them off and get paid at a later date).
I also need to be able to calculate whether an employee is eligable for bank holidays. The ruling is if they have worked 40 hrs in the previous 5 weeks, then they are entitled to the bank holiday. I'm currently using a long winded formula to work this out.
also if anyone can tell me how to attach an excel file, that would be great. can't seem to get the attachment on here
Thanks,
Cormac
Bookmarks