I wish it was as easy as the title says, but unfortunately, that data also needs to be added up to make a grand total of sorts.
I need help with the last bit of my work schedule/attendance points/vacation days and collecting all of that data to put into my two "Master Sheets" that are the first two sheets in my document.
When you open it up it is pretty self-explanatory, especially if you just click through a few sheets.
REQUEST 1
On the second page/sheet, I need to have it list out all of my employees names (First and Last), their remaining vacation days and how many attendance points they have accrued so far. I am hoping that it can auto-add any new employee the minute I create a new attendance area/sheet for that particular person and then it will add him to the list of names and spit out all of his info like the rest.
REQUEST 2
The first page/sheet (looks like a calendar) is a way for me to easily see on one page how many people have put in for vacation for past and future dates "V". It needs to tally up how many employees asked for that particular day off in the top row. As for the bottom row, it needs to calculate all the other types of days off my employees requested or took off. (Excluding the Tardies and Left Earlies)
This new schedule I have been working on has been gaining a lot of attention within my company (traditionally it is all done on paper and was on a word doc). I think if I can get these last two pages doing these things I just requested, my company can finally join the digital age!!!!
Bookmarks