Forewarning: This is a fairly complicated problem; I'm not even sure it's possible, but I will defer to your higher knowledge and wisdom. Perhaps there is an easier solution that I am overlooking, so feel free to offer alternative suggestions as well.
Duties & Schedule.xlsx
I am building a schedule for work. Our managers plan out an employee's tasks ahead of time each day. That job is performed on the "Daily Duty Assignments" tab. My problem resides in the Schedule tab.
What I need this spreadsheet to do is find the left-most cell containing text in an individual employee's row, and then take the time in the corresponding column and input it into the "Start" column on the Schedule tab. Then I need to do the same exact thing with the right most cell that contains text, and input that time into the "End" column.
The whole idea is to avoid taking the time to create two separate schedules, which contain the same basic data. We use the Daily Duty tab format in our daily operations, but the Schedule tab format is used to post a bi-weekly employee schedule in the back room.
I hope this is possible, and I really appreciate any help and feedback that I can get!
Bookmarks