Hello guys,
I have to create a work shift attendance plan system.I have created a calendar template in excel.In 'every business day' cell there are 6 combo boxes (drop down list).Every employee can choose if he is on AM or PM shift. For example: Gabriel - AM, Tomas - PM.Employees make his attendance plan for entire month.
I would like to ask you for a help.I need to solve this:
I need to create an other worksheet.This will be the 'Front page'.I would like to show here the actual attendance for every day.For example according to the calendar on 4th of April there should be Employee1 - PM, Employee2 - PM, Employee3-PM, Employee4 - PM, Employee5 - AM, Employee6 - AM. So I don't need to see the entire month, just the actual day or week. I would like to create a system which automaticaly load information from attendance calendar and show it in the Front page.
Can you help me with this please?
Thank you.
Bookmarks