Hi,
I need help editing a 2010 template.
I started editing a pre-loaded excel template in 2010 version named "Employee Attendance/Leave Tracker." You can access this template directly from excel or it can be found here: http://www.bluelayouts.org/template/1785.html
On the top right hand corner, there's a drop box that allows a user to select an employee. Once an employee is selected, the calendar is automatically changed based on the pre-recorded data.
What I need help is to create another option inside the "Select an Employee" drop box, where it will combine ALL employees, then automatically change the calendar as well as the boxes on the bottom of the pages. The boxes are populated using formulas.
Employee-Tracking-template-8865.jpg
Please help. Thank you in advance.
Bookmarks