Hello everyone,
I need help automating our company’s **daily attendance marking** process using Excel. We currently have two separate files:
1. **Daily Schedule Sheet**: This contains details of the next day's activities for employees, including sections for:
- Job Assignments
- Office Staff
- Off Duty
- Standby
- Sick Leave
- Vacations
- Training
- Transportation
- Site Visits
- Marketing
- Store Duty
Each section lists the employees under it.
2. **Attendance Sheet**: This is where we manually mark the attendance of employees based on the schedule.
### Current Issue:
We are doing double the work by reviewing the **Daily Schedule** and manually updating the **Attendance Sheet**. Since the schedule already lists information like "Off," "Sick Leave," "Standby," etc., I want to automate this process. Only **unauthorized absentees** need to be updated manually.
### Requirement:
I want to automate the attendance marking in the **Attendance Sheet** by pulling data from the **Daily Schedule** sheet. The logic I need is:
1. If an employee is listed as **Off**, **Sick Leave**, **Standby**, or **Vacation** in the **Daily Schedule**, their corresponding status in the **Attendance Sheet** should automatically reflect the same term.
2. If an employee is assigned a task (e.g., a job or project), they should be marked as **Present** in the **Attendance Sheet**.
3. Manual updates are only required for **unauthorized absentees** (those who are expected to be present but are absent).
### Example:
- **Daily Schedule:**
- Off: John Doe
- Sick Leave: Jane Smith
- Project Work: Bob Johnson
- **Attendance Sheet:**
- John Doe: Off
- Jane Smith: Sick Leave
- Bob Johnson: Present
### Desired Solution:
I need a formula or macro that will:
- Automatically update attendance based on the schedule.
- Mark employees as **Present** if assigned to a task, and copy statuses like "Off," "Sick Leave," etc.
- Allow manual updates for **unauthorized absentees**.
Any help with this would be greatly appreciated!
I need help automating our company’s **daily attendance marking** process using Excel. We currently have two separate files:
1. **Daily Schedule Sheet**: This contains details of the next day's activities for employees, including sections for:
- Job Assignments
- Office Staff
- Off Duty
- Standby
- Sick Leave
- Vacations
- Training
- Transportation
- Site Visits
- Marketing
- Store Duty
Each section lists the employees under it.
2. **Attendance Sheet**: This is where we manually mark the attendance of employees based on the schedule.
### Current Issue:
We are doing double the work by reviewing the **Daily Schedule** and manually updating the **Attendance Sheet**. Since the schedule already lists information like "Off," "Sick Leave," "Standby," etc., I want to automate this process. Only **unauthorized absentees** need to be updated manually.
### Requirement:
I want to automate the attendance marking in the **Attendance Sheet** by pulling data from the **Daily Schedule** sheet. The logic I need is:
1. If an employee is listed as **Off**, **Sick Leave**, **Standby**, or **Vacation** in the **Daily Schedule**, their corresponding status in the **Attendance Sheet** should automatically reflect the same term.
2. If an employee is assigned a task (e.g., a job or project), they should be marked as **Present** in the **Attendance Sheet**.
3. Manual updates are only required for **unauthorized absentees** (those who are expected to be present but are absent).
### Example:
- **Daily Schedule:**
- Off: John Doe
- Sick Leave: Jane Smith
- Project Work: Bob Johnson
- **Attendance Sheet:**
- John Doe: Off
- Jane Smith: Sick Leave
- Bob Johnson: Present
### Desired Solution:
I need a formula or macro that will:
- Automatically update attendance based on the schedule.
- Mark employees as **Present** if assigned to a task, and copy statuses like "Off," "Sick Leave," etc.
- Allow manual updates for **unauthorized absentees**.
Any help with this would be greatly appreciated!
