Hi! All,
I am having a bit of problem with an excel workbook. I am attaching an image as well for a better view of what I am trying to accomplish. This is what I want to do:
1. I have one sheet (sheet 1) with the "Employee Names" in one column
2. The other columns have different shifts for different days
3. The hours for the whole week (for each employee) will be posted in the sheet in-front of the employee's name
4. There are other sheets (e.g. sheet 2) for each day of the week. In those sheets the columns will be divided by shifts as in the first sheet (sheet 1)
5. as soon as hours are entered in the first sheet (sheet 1) for an employee, the employee's name appears under the corresponding shift in the sheet for that day (sheet 2).
I would really appreciate it if anyone can help me with this. If something is not clear, please let me know. Thanks to everyone who comments.
I am having a bit of problem with an excel workbook. I am attaching an image as well for a better view of what I am trying to accomplish. This is what I want to do:
1. I have one sheet (sheet 1) with the "Employee Names" in one column
2. The other columns have different shifts for different days
3. The hours for the whole week (for each employee) will be posted in the sheet in-front of the employee's name
4. There are other sheets (e.g. sheet 2) for each day of the week. In those sheets the columns will be divided by shifts as in the first sheet (sheet 1)
5. as soon as hours are entered in the first sheet (sheet 1) for an employee, the employee's name appears under the corresponding shift in the sheet for that day (sheet 2).
I would really appreciate it if anyone can help me with this. If something is not clear, please let me know. Thanks to everyone who comments.