Formula needed to display Break and Lunch Times from another sheet

Here is the file: -Working-Incremental Schedule - 2014.xlsm

Hello I have 2 sheets.

Sheet 1. Current Schedule
Sheet 2. Incremental

In sheet 1 I have a list of people in column A and they all have cells that proceed with Break and lunch times like so:

Sheet 1. Current Schedule

A1: Name
B1: Start Time
C1: B1 Start
D1: B1 End
E1: Lunch
F1: Lunch End
G1: B2 Start
H1: B2 End
I1: End Time


In Sheet 2 I have the same people in column A listed but grouped by team order (which is not important to my request) and from columns B1 through AT1 the times of the day from 7 am to 6 pm are listed in 15 minute increments like so:

Sheet 2: Incremental

7:00 7:15 7:30 7:45 8:00 8:15 8:30 8:45 9:00 9:15 9:30 9:45 10:00 10:15 10:30 10:45 11:00 11:15 11:30 11:45 12:00 12:15 12:30 12:45 1:00 1:15 1:30 1:45 2:00 2:15 2:30 2:45 3:00 3:15 3:30 3:45 4:00 4:15 4:30 4:45 5:00 5:15 5:30 5:45 6:00

Also in Sheet 2 Incremental Each Agent Will have a Start, Break 1, Lunch, Break 2 and End Text on their row under the specified column matching the times above.


I need a forumla to place in sheet one that search the persons name from sheet 1 (Column A), find the same person in sheet 2, and list their Start Time, Break 1, Lunch, Break 2 and End times.

Here is the file: -Working-Incremental Schedule - 2014.xlsm

test the macro list

Job well done rcm!! This is exactly what I needed. Thanks again for the amazing work!

Originally Posted by rcm

test the macro list