Hello.
Here is what I am looking to do: on one sheet of my workbook is an activity log. Users will plug in a date and in the next cell they will record an activity. On the second sheet I would like to have a yearly calendar. When the user plugs in, say 1/1/2012 and logs activity, the calendar will update. After logging an event, that date's cell will change colors on the second sheet.
Example:
On 12/5/2012 an employee was absent.
The cell for 12/5/2012 on the calendar is now filled in red.
On 12/1/2012 an employee was tardy
The cell for 12/1/2012 is now filled in yellow.
Any thoughts on how to accomplish this?
Here is what I am looking to do: on one sheet of my workbook is an activity log. Users will plug in a date and in the next cell they will record an activity. On the second sheet I would like to have a yearly calendar. When the user plugs in, say 1/1/2012 and logs activity, the calendar will update. After logging an event, that date's cell will change colors on the second sheet.
Example:
On 12/5/2012 an employee was absent.
The cell for 12/5/2012 on the calendar is now filled in red.
On 12/1/2012 an employee was tardy
The cell for 12/1/2012 is now filled in yellow.
Any thoughts on how to accomplish this?