Itsjustmeh
New Member
- Joined
- Sep 14, 2014
- Messages
- 1
-breakdown sheet PIC View image: Shift Breakdown
- Schedule sheet PIC View image: Schedule Sheet
hope someone can help me,
I manage schedules in my job, but with a lot of employees, takes a lot of my time...
Currently I have a schedule sheet and a breakdown sheet...
Each day I look at the schedule and manually type employees name on the breakdown sheet based on where they are scheduled to be located and at what time they start.
I would like a micro to help me fill in sheet2 (breakdown)
here is what I would like it to do...
-at schedule sheet, look at current date column (example 1-sep) if an employee has a start time in that column, get location and name
-at sheet 2(breakdown) look for location, insert name next to their start time.
-repeat until all employees names scheduled today (1-sep) are in sheet 2.
if you require more info ask me, I thank you in advance.
- Schedule sheet PIC View image: Schedule Sheet
hope someone can help me,
I manage schedules in my job, but with a lot of employees, takes a lot of my time...
Currently I have a schedule sheet and a breakdown sheet...
Each day I look at the schedule and manually type employees name on the breakdown sheet based on where they are scheduled to be located and at what time they start.
I would like a micro to help me fill in sheet2 (breakdown)
here is what I would like it to do...
-at schedule sheet, look at current date column (example 1-sep) if an employee has a start time in that column, get location and name
-at sheet 2(breakdown) look for location, insert name next to their start time.
-repeat until all employees names scheduled today (1-sep) are in sheet 2.
if you require more info ask me, I thank you in advance.
