Ok I'm sorry but not sure how to explain this. I am trying to create a excel program to keep track of employees accrued vacation time, hours used and there running total. that was the easy part for me but I also need to keep track of the day and hours each employee used vacation time I want to make this as easy as possible to enter the hours taken by a employee. I was hoping there was a way to list the employee names at the top of a table with the date down the first column and make a drop down menu for the month and year but I have no clue how to do this. any help would be greatly appreciated I have attached the work in progress file sheet one is set up so I can add the employees to the database and it populates the names and accrued amount of hours each month and there starting month of accrual I have also tied in a used hours column for each month so as new employees are added to the form they can be alphabetized and all the current data for each employee follows the employee in sheet 2. sheet two is the running total of accrued hours, used hours and there balance at the end of each month as I have to give out what each employee has available at this time and a projected total in a fee months out if they didn't use any hours between now and then. Sheet 3 is similar to what I am trying to do for a simple way to enter time used each month by each employee. when this is done and ready for use there will be around 40 employees being tracked.
thanks in advance for helping me with this

Attached Files

VACATION HOURS.xlsx (57.7 KB, 12 views)

Surprisingly, this is something that Google sheets automatically does that Excel does not, as far as I know anyway. And Google sheets is much more collaborative than Excel.