Excel Drop Down List

Question

Hello,

I have created a drop down list for all employees at my job to track their attendance, however I do not know how to have the monthly attendance record change along with each name selected.  If that makes sense.

I need each individual employee to have their own attendance record, however I am not trying to create 200+ records.

Thanks!

Answer 1

I was able to do the drop down list.  I have a two completely different question now.

1. How do I get the calendar to color code like the 4 original occurrences that were on the template?  I added 3 new categories to my worksheet.

2. I've created a table on a separate worksheet with all the employee names and the type of occurrences as headers. We have a point system and I'm unable to figure out how to create a formula that will pull from the Employee Leave Tracker tab and calculate the points.  I'm unsure how to create the formula because the names aren't in any specific order, however I need a formula that will locate the employees name, occurrence, the point(s) that were given for that particular infraction.    

IE- Bob was Tardy by 10 min 9/19/16, he gets .50, Bob was tardy 9/21/16 by 2 hrs he gets 1 point.  Now he has a total of 1.50 points for under Column F/Late Tardy.

Answer 2

Hi Lourdes,

I understand that you want help with Excel drop down list.

As per your issue, I suggest you to refer to the following article and check if it helps in resolving your issue:

https://support.office.com/en-us/article/Create-a-drop-down-list-7693307A-59EF-400A-B769-C5402DCE407B

Please post to us if you need any further assistance and we will assist you.

Thank you.