Forum Discussion
Adapt a Template
I downloaded a template (Employee attendance record) that has 5 sheets. The first a Calendar view showing days on leave, working days, # sick days, vacation, bereavement, and other. the second sheet with leave dates and reason, showing number of days off. The Third sheet, showing employees. The fourth sheet showing reasons, and the fifth sheet showing holidays.
My attempt is to repurpose the workbook to show scheduled positions, and to graph, or show in the: days on leave, working days, # sick days, vacation, bereavement, and other as positions. As is, the days on leave, working days, # sick days, vacation, bereavement, and other are color coded, which is fine, with the exception of Sundays. Sundays could have 2 different positions - needing 2 different colors.
What are your thoughts? I would prefer not to start from scratch, as I like the setup.
Could you attach a small sample workbook based on the template (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Then, in your reply, please indicate in more detail what you would like to change/add.
OK, could you explain in more detail what you want, or post that video?
