Looking for help making employee days work and holiday tracker more user friendly.

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

To attach a file, click on Go Advanced at the bottom right corner of the edit window while you are composing a post, then scroll down to and click on Manage Attachments - a new window will pop up. Click on Browse, then navigate to the file icon that you want to attach and double-click it, then click Upload | Close this window to get back to your post, then Submit Reply when you have finished.

Hope this helps.

Pete

Here's the file.

thanks for your very quick and positive comments so far!

Hi LokeshKumar,

just wondering if you were able to take a look at the file to see if you could advise on any way to make it simpler?

Hi Newdoverman,

I probably don't understand exactly what you are proposing but would it not just be my existing document just on 1 worksheet and arranged vertically instead of horizontally?