Save Data Automatically with Excel Calendar

Last Updated on 01/06/2024
Reading time: 2 minutes

Discover our calendar for Excel that will save your data automatically for each month

Demo Calendar Excel

Contents of the workbook

The workbook consists of 3 worksheets

  • The calendar
  • Parameters
  • Data history

Each new addition or modification to the calendar generates a record in the Historical Data sheet. VBA generates all the automation (don't change the code to avoid failure).

Download the workbook

Click on the following button To download the calendar

Unblock workbook macros

Microsoft recently blocked all files containing VBA for workbooks from the Internet. To make the file usable, proceed as follows

Unblock file with macros

How does the calendar work?

Each time a cell is updated, the system immediately saves the information in the Historical Data sheet.

The Historical Data sheet is fundamental to using the workbook and the VBA program. If you modify the structure (add or remove columns), the program will not work.

Which data can you fill in the cells?

The program doesn't control the type of data you fill. You can fill any of these types of data:

  • Whole numbers
  • Decimal numbers
  • Hourly numbers
  • Or letters.

Add a new employee.

When you enter a new employee in column A of the calendar, the formula that sums the working days automatically adds to column B.

Autofill data for an employee.

If you need to enter the same value for each employee, you can use the following procedure:

  1. Double-click an employee's name
  2. All cells corresponding to the working days of the current month will automatically fill with the value specified in the Settings sheet.
Employee Double Click

If data is already on the row, an alert message will ask if you want to overwrite the existing data.

Delete values

When you delete the values from one or more cells, the system deletes the data from the Historical Data sheet.

Delete all employee data for the selected month.

You can delete an employee's data by simply clearing their name from column A.

Remove Employee Name

Change an employee's name.

If you want to correct an employee's name on the Calendar sheet, the system will automatically correct the name on the Historical Data sheet.

Can I change the colors, the font, and the width of the columns?

You can change any calendar formatting with no impact on the execution of the program.

  • Color of the employee column, Date's row
  • Font of any cell
  • Width of any column of the calendar

You can also change the color of weekends and holidays by changing the colors of conditional formatting.

BUT, if you apply a specific color for a day, this information will not be saved.

What is forbidden to do?

  • Change VBA Program
  • Rename worksheets
  • Adding rows or columns that change the structure of the Calendar (column of the employees, row for the calendar days)
  • Change calendar layout (swapping rows and columns)
  • Edit the Historical Data sheet

NOTE: If you take the initiative to change the VBA program or the workbook structure, the risk of the workbook not working is very high. We cannot be held responsible in any way for malfunctions found following a change in the code or structure of the workbook.

4 Comments

  1. Ryne
    13/12/2023 @ 02:01

    when i add employees and fill out a date, when i switch months it deletes all added employees and information added. what should i do i am having a hard time

    Reply

  2. Ryne
    11/12/2023 @ 19:15

    This is amazing i purchased the workbook, but i need to add more employees how can i do this and not ruin the workbook?

    Reply

    • FrĂ©dĂ©ric LE GUEN
      12/12/2023 @ 01:34

      Thanks. There is no limitation. You can add as many employees as you want.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Save Data Automatically with Excel Calendar

Reading time: 2 minutes
Last Updated on 01/06/2024

Discover our calendar for Excel that will save your data automatically for each month

Demo Calendar Excel

Contents of the workbook

The workbook consists of 3 worksheets

  • The calendar
  • Parameters
  • Data history

Each new addition or modification to the calendar generates a record in the Historical Data sheet. VBA generates all the automation (don't change the code to avoid failure).

Download the workbook

Click on the following button To download the calendar

Unblock workbook macros

Microsoft recently blocked all files containing VBA for workbooks from the Internet. To make the file usable, proceed as follows

Unblock file with macros

How does the calendar work?

Each time a cell is updated, the system immediately saves the information in the Historical Data sheet.

The Historical Data sheet is fundamental to using the workbook and the VBA program. If you modify the structure (add or remove columns), the program will not work.

Which data can you fill in the cells?

The program doesn't control the type of data you fill. You can fill any of these types of data:

  • Whole numbers
  • Decimal numbers
  • Hourly numbers
  • Or letters.

Add a new employee.

When you enter a new employee in column A of the calendar, the formula that sums the working days automatically adds to column B.

Autofill data for an employee.

If you need to enter the same value for each employee, you can use the following procedure:

  1. Double-click an employee's name
  2. All cells corresponding to the working days of the current month will automatically fill with the value specified in the Settings sheet.
Employee Double Click

If data is already on the row, an alert message will ask if you want to overwrite the existing data.

Delete values

When you delete the values from one or more cells, the system deletes the data from the Historical Data sheet.

Delete all employee data for the selected month.

You can delete an employee's data by simply clearing their name from column A.

Remove Employee Name

Change an employee's name.

If you want to correct an employee's name on the Calendar sheet, the system will automatically correct the name on the Historical Data sheet.

Can I change the colors, the font, and the width of the columns?

You can change any calendar formatting with no impact on the execution of the program.

  • Color of the employee column, Date's row
  • Font of any cell
  • Width of any column of the calendar

You can also change the color of weekends and holidays by changing the colors of conditional formatting.

BUT, if you apply a specific color for a day, this information will not be saved.

What is forbidden to do?

  • Change VBA Program
  • Rename worksheets
  • Adding rows or columns that change the structure of the Calendar (column of the employees, row for the calendar days)
  • Change calendar layout (swapping rows and columns)
  • Edit the Historical Data sheet

NOTE: If you take the initiative to change the VBA program or the workbook structure, the risk of the workbook not working is very high. We cannot be held responsible in any way for malfunctions found following a change in the code or structure of the workbook.

4 Comments

  1. Ryne
    13/12/2023 @ 02:01

    when i add employees and fill out a date, when i switch months it deletes all added employees and information added. what should i do i am having a hard time

    Reply

  2. Ryne
    11/12/2023 @ 19:15

    This is amazing i purchased the workbook, but i need to add more employees how can i do this and not ruin the workbook?

    Reply

    • FrĂ©dĂ©ric LE GUEN
      12/12/2023 @ 01:34

      Thanks. There is no limitation. You can add as many employees as you want.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *