Creating a calendar function
 

I am in charge of tracking vacation and sick time for our employees. I have
over 30 people that I made individual spreadsheets for that records these two
categories. Then I have to manually enter their days into another calendar so
that we can compare days off relative to other employees.

Is there a way that when I enter the date and hours into the table, that it
will automatically populate on the calendar or vice versa?

Creating a calendar function
 

Most likely, although it can only go one way, i.e. always enter on the table
and the calendar is automatically updated or always enter on the calendar and
the table is updated. You'll need to provide more information regarding the
spreadsheet set up, e.g. what exactly is being entered in the table, in what
cells is the information appearing, how is the calendar set up, etc.

"Meggyash08" wrote:

I am in charge of tracking vacation and sick time for our employees. I have
over 30 people that I made individual spreadsheets for that records these two
categories. Then I have to manually enter their days into another calendar so
that we can compare days off relative to other employees.

Is there a way that when I enter the date and hours into the table, that it
will automatically populate on the calendar or vice versa?