Hi, I am using the employee attendance tracker template in Excel. It has been great. However, i wanted to see if there is an easy way to create a tab where it can do a complete rollup of all the employees out. Using the same layout as the calendar view, just to see which days someone is taking off (no need to specify who) and just to see it all collectively rolled up. Is that something easy to do? any help is greatly appreciated!
Hi buhhan,
Could you post an example file to see what you mean?
Thanks
Remember you are unique, like everyone else
sure, see attached. again, wanting to create a new tab like the "Calendar View" tab that show any day highlighted where someone is taking it off as a whole group, rather than 1-by-1.
I've never attached anything on a post before, so hoping it worked. let me know if it doesn't and I will try again.
Hi buhhan,
I've created a Pivot Table that summarises the 'Employee Leave Tracker' worksheet.
Is this what you were thinking of?
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks