Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a calendar in excel with the data from another spreadshee | Excel Discussion (Misc queries) | |||
Creating a Calendar | Excel Discussion (Misc queries) | |||
Creating an annual marketing event calendar | Excel Discussion (Misc queries) | |||
Creating a Calendar | Excel Discussion (Misc queries) | |||
Creating a calendar in a cell for a date-picker | Excel Worksheet Functions |