Discover our calendar data saving in Excel to record your timesheet every month.

• Automatically save your data when you change the month.
• Record any updates instantly.
• Remove an employee’s name to delete all data on the same row.
• Double-click an employee’s name to fill all data on the row.

Contents of the workbook

This workbook has 3 worksheets:

• The calendar
• Settings
• Historical data

When you update the calendar, the information is saved in the Historical Data sheet. VBA handles the automation. Do not change the VBA code to avoid issues.

Download the workbook

Click the button below to download the calendar:

Unblock workbook macros

Microsoft recently blocked VBA files downloaded from the Internet. To use the file, follow these steps to unblock macros.

How does the calendar work?

When you change a cell, the data is saved to the Historical Data sheet. Do not change the sheet's structure, or it will not work properly.

Which data can you fill in the cells?

You can use different data types in the calendar:

• Whole numbers
• Decimal numbers
• Hours and minutes
• Text

Add a new employee

Enter a new employee's name in column A. The formula will automatically calculate the working days in column B.

Autofill data for an employee

To repeat a value for all working days of the month, use this method:

1. Double-click the employee's name
2. The cells for the working days will be filled automatically.

If there is data in those cells, the system will ask if you want to overwrite it.

Delete values

Deleting values from the calendar will also remove them from the Historical Data sheet.

Delete all employee data for the selected month

To delete an employee's data, clear their name from column A.

Change an employee's name

Changing an employee's name on the Calendar sheet will update the name on the Historical Data sheet too.

Can I change the colors, the font, and the column width?

You can change the calendar's appearance without affecting how it works:

• Change colors of cells
• Adjust fonts
• Resize columns

You can change the colors of weekends and holidays using conditional formatting.

IMPORTANT: The calendar only saves cell values, such as text or numbers. It does not record colors used as data.

What should you not do?

• Change the VBA program
• Rename any worksheet
• Add rows or columns that change the calendar's structure
• Swap rows and columns
• Edit the Historical Data sheet

WARNING: If you change the VBA code or the structure of the workbook, it may not work. We are not responsible for any problems caused by these changes.

Calendar Data Saving

Calendar data saving is crucial. Remember, modifying the VBA or data structure may cause errors.