Automate employee absence sheet

**Lucy193** · 09-17-2021, 06:19 AM

Hi all,

I am trying to create an automated employee absence sheet. My aim is to have an option of choosing a specific month and assign specific reasons for employees´ absence to the month. I have used macros to do this, however the only problem I am having is: I write e.g. that in September 15th a specific employee was sick and then I pre-click on other month and thank go back to September, my note I made on the 15th disappears. I have used "ClearContents" when doing Macros, but I do not want the contents to be cleared once I have made a note in the specific month. Hope that make sense and someone will be able to help with this.

Many thanks,

Lucy

**6StringJazzer** · 09-17-2021, 10:17 AM

You have not designed any way to preserve the data for one month once you switch to another month. I recommend you add a master data sheet to capture all data. When you make changes in a month it is saved in the master data sheet. When you change months, the data is retrieved from the master. This is a little complicated but I find it interesting so I am seeing if I can write a solution.

**6StringJazzer** · 09-18-2021, 09:55 AM

Here is something for you to try. I had to make two small changes to your sheet:

The dates in row 6 where not correct dates. They used the index of the year dropdown (1, 2) as the year. I changed it to use the year itself as the year.
AP5 used the index of the year dropdown (1, 2) as the year. I changed it to use the year itself as the year.

When you make any changes to the month sheet, the absences will be stored in sheet Master. If you switch to a different month, the absences saved on Master for that month will be reloaded.

Automate employee absence sheet

LinkBack

Thread Tools

Rate This Thread

Display

Automate employee absence sheet

Re: Automate employee absence sheet

Re: Automate employee absence sheet

Thread Information

Users Browsing this Thread

Similar Threads

Employee Absence Schedule modeling

Employee Absence Schedule

[SOLVED] Creating a summary box from existing employee absence data

Absence Tracker Template by employee

[SOLVED] Employee Absence Schedule

[SOLVED] Employee Absence Schedule Template

Check this Employee was off or Absence

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions