Hello,
I am trying to complete the following action, and am not sure how to begin.
I have 1 Work book and 2 sheets.
On sheet 1 I have a list of employees and thier employee number
there is also a monthly grid for the year beside the list of names
----------------------------------------
-Example
Employee id | Name | Jan | Feb | March | Etc..
12345 John Doe
----------------------------------------
On sheet 2 I have what I am calling a running list of absenteeism.
-----------------------------------------
-Example
Employee id | Name |Date Sick | Date Returned | Total days | Visit
12345 John Doe 03-01-2013 03-06-2013 5 Yes
-----------------------------------------
I would like the following actions to take place
- When entering the employee id on page 2 I would like it to match to the employee id on page 1 and copy the corresponsing name on that line over to page 2.
- When an absence date is entered I would like the total days copied to sheet 1 in the appropriate month.
- If there is more then one absences entry for an employee in the same month I would like it to add the total days
- If there is a visit in the entry I would like it to highlight or color the field in the month of the visit.
I hope that makes sense! Any help is really appreciated, If I am looking for too much.. I understand.
Thanks!
~AZ
I am trying to complete the following action, and am not sure how to begin.
I have 1 Work book and 2 sheets.
On sheet 1 I have a list of employees and thier employee number
there is also a monthly grid for the year beside the list of names
----------------------------------------
-Example
Employee id | Name | Jan | Feb | March | Etc..
12345 John Doe
----------------------------------------
On sheet 2 I have what I am calling a running list of absenteeism.
-----------------------------------------
-Example
Employee id | Name |Date Sick | Date Returned | Total days | Visit
12345 John Doe 03-01-2013 03-06-2013 5 Yes
-----------------------------------------
I would like the following actions to take place
- When entering the employee id on page 2 I would like it to match to the employee id on page 1 and copy the corresponsing name on that line over to page 2.
- When an absence date is entered I would like the total days copied to sheet 1 in the appropriate month.
- If there is more then one absences entry for an employee in the same month I would like it to add the total days
- If there is a visit in the entry I would like it to highlight or color the field in the month of the visit.
I hope that makes sense! Any help is really appreciated, If I am looking for too much.. I understand.
Thanks!
~AZ