Attendance Tracker help

Hello all. New to the forums and have learned quite a bit from reading over the posts here. As for my issue, i have attached the general spreadsheet i have constructed with no formulas added as of yet. However i need some ideas on how to acheive what i need. As you can tell there are about 300 folks i am responsible for tracking. I am going to have each supervisor put an x by the name of the person if they are out. No other inputs will be put in. i would also like to have a daily absenteeism rate, and a way to go back and look at a range to see average % of people absent. Or maybe even a monthly graph showing absenteeism.....any suggestions?

Any help or suggestions?

Hi CHill0828

I had a very similar problem to overcome - matching names, offsetting and putting an 'x' next to the persons name, and under a date.
See thread here, where I've posted my final code (of course, I had help from others )

http://www.excelforum.com/excel-prog...on-system.html

Hope that helps!