Attendance Tracking/Time Differences

Hey everyone,

Just looking for some general guidance as I'm not sure where to start.

I have a list of shifts (In "Data Main (2)" spreadsheet) worked by a team member. I am looking to populate the 'Intended Start Time' field based on the 'Day of Week' field and 'Analyst' name.

Each Analyst has a different 'Intended Start Time' on any given day of the week. I've created a 'Shifts' worksheet to list the Analyst Name, Day, and Start Time. My intent would be to have the macro check the Agent Name and Day of Week in the Data Main spreadsheet, and find the correct Intended Start shift in the Shifts spreadsheet. Does this make sense, or is there a better way of doing it?


Thanks!