Pulling/Linking Data from one sheet to the next

C

chrono2483

Board Regular
Joined
Aug 23, 2014
Messages
164
Office Version
  1. 2016
Good Morning. I am currently working on a tool, where I have a Macro in place to clean up and extract unnecessary data. What is left, I want to be able to pull key cell info and place it in a table on a separate sheet.

- The data as well as cell location will not be the same each time
- There are no unique headings in place
-

Would a V or H Lookup, or a Index() Match() work with this situation?

Below is a snapshot of the worksheet, and what I am trying to accomplish:


Sheet1:

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[TD="align: center"]G
[/TD]
[TD="align: center"]H
[/TD]
[TD="align: center"]I
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]Agent: John Doe
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]Date: 1/01/15
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]Scheduled
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]Actual
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]
[TABLE="width: 71"]
<tbody>[TR]
[TD]Scheduled
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 104"]
<tbody>[TR]
[TD]Actual
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 101"]
<tbody>[TR]
[TD]Variance
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]From
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]To
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]Duration
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]From
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]To
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]Duration
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 71"]
<tbody>[TR]
[TD]Activity
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 104"]
<tbody>[TR]
[TD]Activity
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 101"]
<tbody>[TR]
[TD]Description
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]12:15 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]12:01 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]00:01
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD="align: center"]
[TABLE="width: 104"]
<tbody>[TR]
[TD]NotReady / Pas Prêt
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 101"]
<tbody>[TR]
[TD]Unscheduled Event
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]12:05 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]1:13 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]01:08
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 71"]
<tbody>[TR]
[TD]Open/Ouvert
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]12:07 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]12:10 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]00:03
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]
[TABLE="width: 104"]
<tbody>[TR]
[TD]SignOff
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 101"]
<tbody>[TR]
[TD]Unscheduled Event
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"]8
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]1:27 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]1:30 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]00:03
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 71"]
<tbody>[TR]
[TD]Open/Ouvert
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]1:28 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]1:39 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]00:11
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]
[TABLE="width: 104"]
<tbody>[TR]
[TD]SignOff
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 101"]
<tbody>[TR]
[TD]Unscheduled Event
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"]10
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]1:39 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]1:41 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]00:02
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]
[TABLE="width: 104"]
<tbody>[TR]
[TD]NotReady / Pas Prêt
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 101"]
<tbody>[TR]
[TD]Unscheduled Event
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"]11
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]1:30 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 53"]
<tbody>[TR]
[TD="align: center"]1:45 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 47"]
<tbody>[TR]
[TD="align: center"]00:15
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 53"]
<tbody>[TR]
[TD="align: center"]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 47"]
<tbody>[TR]
[TD="align: center"]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 47"]
<tbody>[TR]
[TD="align: center"]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 71"]
<tbody>[TR]
[TD="align: center"]Break/Pause
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]12
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]Agent: Jane Doe
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]13
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]Date: 1/01/15
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]14
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]Scheduled
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD]
[TABLE="width: 53"]
<tbody>[TR]
[TD="align: center"]Actual
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD]
[TABLE="width: 71"]
<tbody>[TR]
[TD="align: center"]Scheduled
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 104"]
<tbody>[TR]
[TD="align: center"]Actual
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 101"]
<tbody>[TR]
[TD="align: center"]Variance
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"]15
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]From
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 53"]
<tbody>[TR]
[TD="align: center"]To
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 47"]
<tbody>[TR]
[TD="align: center"]Duration
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 53"]
<tbody>[TR]
[TD="align: center"]From
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 53"]
<tbody>[TR]
[TD="align: center"]To
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 47"]
<tbody>[TR]
[TD="align: center"]Duration
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 71"]
<tbody>[TR]
[TD="align: center"]Activity
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 104"]
<tbody>[TR]
[TD="align: center"]Activity
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 101"]
<tbody>[TR]
[TD="align: center"]Description
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"]16
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]9:03 AM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]9:01 AM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]00:01
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]
[TABLE="width: 104"]
<tbody>[TR]
[TD]NotReady / Pas Prêt
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 101"]
<tbody>[TR]
[TD]Unscheduled Event
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"]17
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]9:00 AM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]10:30 AM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]01:30
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 71"]
<tbody>[TR]
[TD]Open/Ouvert
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]18
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]10:30 AM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]10:45 AM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]00:15
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 71"]
<tbody>[TR]
[TD]Break/Pause
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]19
[/TD]
[TD="align: center"]
[TABLE="width: 260"]
<tbody>[TR]
[TD]10:45 AM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]12:15 PM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]01:30
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 53"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 47"]
<tbody>[TR]
[TD]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 71"]
<tbody>[TR]
[TD]Open/Ouvert
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]20
[/TD]
[TD]
[TABLE="width: 260"]
<tbody>[TR]
[TD="align: center"]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 53"]
<tbody>[TR]
[TD="align: center"]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 47"]
<tbody>[TR]
[TD="align: center"]--:--
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 53"]
<tbody>[TR]
[TD="align: center"]11:20 AM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 53"]
<tbody>[TR]
[TD="align: center"]11:35 AM
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 47"]
<tbody>[TR]
[TD="align: center"]00:15
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"][/TD]
[TD]
[TABLE="width: 104"]
<tbody>[TR]
[TD="align: center"]SignOff
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]
[TABLE="width: 101"]
<tbody>[TR]
[TD="align: center"]Unscheduled Event
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


Sheet2:



[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD="align: center"]
[TABLE="width: 81"]
<tbody>[TR]
[TD]Date
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 136"]
<tbody>[TR]
[TD]Agent Name
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 141"]
<tbody>[TR]
[TD]Scheduled Start Time
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: center"]
[TABLE="width: 126"]
<tbody>[TR]
[TD]Actual Start Time
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]



Goal:

I would like to create a Macro, or use formula's in Sheet2. This will pull the required data from Sheet1. The data pulled are:

- Date: There may be one or multiple dates in question. The format of the date cell in Sheet1 will be the same ('Date: 1/01/15')
- Agent Name: Agent Names and the number of agents listed will vary all the time, however the format will remain the same ('Agent: Jane Doe')
- Scheduled Start Time: Cell location will vary, also will need to pull start time for each agent in Sheet1, however will always be in Col. A, and will always be the first time-stamp for each agent.
- Actual Start Time: Cell location will vary, also will need to pull start time for each agent in Sheet1, however will always be in Col. D, and will always be the first time-stamp for each agent.


Would someone be able to assist with the best way of achieving this goal. I hope I have explained clearly, but can further clarify.

Thank you in advance!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
put the same data in a spreadsheet, copy it, and paste it in the reply box

it is very scrambled at present
 
Upvote 0
[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]john doe[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]planned[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]from[/TD]
[TD]to[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl24, align: right"]08:00[/TD]
[TD="class: xl24, align: right"]11:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]actual[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]from[/TD]
[TD]to[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl24, align: right"]08:09[/TD]
[TD="class: xl24, align: right"]11:14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl24, align: right"]11:45[/TD]
[TD="class: xl24, align: right"]15:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl24, align: right"]11:40[/TD]
[TD="class: xl24, align: right"]15:10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]jane doe[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]planned[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]from[/TD]
[TD]to[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl24, align: right"]08:00[/TD]
[TD="class: xl24, align: right"]11:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]actual[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]from[/TD]
[TD]to[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl24, align: right"]08:09[/TD]
[TD="class: xl24, align: right"]11:14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="class: xl24, align: right"]11:45[/TD]
[TD="class: xl24, align: right"]15:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl24, align: right"]11:40[/TD]
[TD="class: xl24, align: right"]15:10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Hi oldbrewer, Is there a trick to coping/pasting into the reply box? I have the data in a spreadsheet, but unable to paste into the reply box. Thanks!
 
Upvote 0
Sheet1:

[TABLE="width: 576"]
<tbody>[TR]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"]A[/TD]
[TD="class: xl63, width: 64, align: center"]B[/TD]
[TD="class: xl63, width: 64, align: center"]C[/TD]
[TD="class: xl63, width: 64, align: center"]D[/TD]
[TD="class: xl63, width: 64, align: center"]E[/TD]
[TD="class: xl63, width: 64, align: center"]F[/TD]
[TD="class: xl63, width: 64, align: center"]G[/TD]
[TD="class: xl63, width: 64, align: center"]H[/TD]
[TD="class: xl63, width: 64, align: center"]I[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, align: center"]1[/TD]
[TD="class: xl63, width: 64, align: center"]Agent: John Doe[/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]2[/TD]
[TD="class: xl64, align: center"]Date: 1/18/15[/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: center"]3[/TD]
[TD="class: xl65, align: center"]Scheduled[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"]Actual[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"]Scheduled[/TD]
[TD="class: xl65, align: center"]Actual[/TD]
[TD="class: xl65, align: center"]Variance[/TD]
[/TR]
[TR]
[TD="class: xl65, align: center"]4[/TD]
[TD="class: xl65, align: center"]From[/TD]
[TD="class: xl65, align: center"]To[/TD]
[TD="class: xl65, align: center"]Duration[/TD]
[TD="class: xl65, align: center"]From[/TD]
[TD="class: xl65, align: center"]To[/TD]
[TD="class: xl65, align: center"]Duration[/TD]
[TD="class: xl65, align: center"]Activity[/TD]
[TD="class: xl65, align: center"]Activity[/TD]
[TD="class: xl65, align: center"]Description[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]5[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl67, align: center"]12:15 PM[/TD]
[TD="class: xl66, align: center"]12:01 PM[/TD]
[TD="class: xl66, align: center"]00:01[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]NotReady / Pas Prêt[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]6[/TD]
[TD="class: xl66, align: center"]12:05 PM[/TD]
[TD="class: xl66, align: center"]1:13 PM[/TD]
[TD="class: xl66, align: center"]01:08[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Open/Ouvert[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]7[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]12:07 PM[/TD]
[TD="class: xl66, align: center"]12:10 PM[/TD]
[TD="class: xl66, align: center"]00:03[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]SignOff[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]8[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]1:27 PM[/TD]
[TD="class: xl66, align: center"]1:28 PM[/TD]
[TD="class: xl66, align: center"]00:01[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]NotReady / Pas Prêt[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]9[/TD]
[TD="class: xl66, align: center"]1:27 PM[/TD]
[TD="class: xl66, align: center"]1:30 PM[/TD]
[TD="class: xl66, align: center"]00:03[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Open/Ouvert[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]10[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]1:28 PM[/TD]
[TD="class: xl66, align: center"]1:39 PM[/TD]
[TD="class: xl66, align: center"]00:11[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]SignOff[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]11[/TD]
[TD="class: xl66, align: center"]1:30 PM[/TD]
[TD="class: xl66, align: center"]1:45 PM[/TD]
[TD="class: xl66, align: center"]00:15[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Break/Pause[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]12[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]1:39 PM[/TD]
[TD="class: xl66, align: center"]1:41 PM[/TD]
[TD="class: xl66, align: center"]00:02[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]NotReady / Pas Prêt[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]13[/TD]
[TD="class: xl66, align: center"]1:45 PM[/TD]
[TD="class: xl66, align: center"]3:45 PM[/TD]
[TD="class: xl66, align: center"]02:00[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Open/Ouvert[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]14[/TD]
[TD="class: xl66, align: center"]3:45 PM[/TD]
[TD="class: xl66, align: center"]4:15 PM[/TD]
[TD="class: xl66, align: center"]00:30[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Lunch/Repas[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]15[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]4:09 PM[/TD]
[TD="class: xl66, align: center"]4:39 PM[/TD]
[TD="class: xl66, align: center"]00:30[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]SignOff[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]16[/TD]
[TD="class: xl66, align: center"]4:15 PM[/TD]
[TD="class: xl66, align: center"]5:45 PM[/TD]
[TD="class: xl66, align: center"]01:30[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Open/Ouvert[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]17[/TD]
[TD="class: xl66, align: center"]5:45 PM[/TD]
[TD="class: xl66, align: center"]6:00 PM[/TD]
[TD="class: xl66, align: center"]00:15[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Break/Pause[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]18[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]5:59 PM[/TD]
[TD="class: xl66, align: center"]6:14 PM[/TD]
[TD="class: xl66, align: center"]00:15[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]SignOff[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]19[/TD]
[TD="class: xl66, align: center"]6:00 PM[/TD]
[TD="class: xl66, align: center"]8:00 PM[/TD]
[TD="class: xl66, align: center"]02:00[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Open/Ouvert[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]20[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]6:59 PM[/TD]
[TD="class: xl66, align: center"]7:16 PM[/TD]
[TD="class: xl66, align: center"]00:17[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]SignOff[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]21[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]7:47 PM[/TD]
[TD="class: xl66, align: center"]8:00 PM[/TD]
[TD="class: xl66, align: center"]00:13[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]SignOff[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, align: center"]22[/TD]
[TD="class: xl63, width: 64, align: center"]Agent: Jane Doe[/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[TD="class: xl63, width: 64, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl64, align: center"]23[/TD]
[TD="class: xl64, align: center"]Date: 1/18/15[/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[TD="class: xl64, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl65, align: center"]24[/TD]
[TD="class: xl65, align: center"]Scheduled[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"]Actual[/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"][/TD]
[TD="class: xl65, align: center"]Scheduled[/TD]
[TD="class: xl65, align: center"]Actual[/TD]
[TD="class: xl65, align: center"]Variance[/TD]
[/TR]
[TR]
[TD="class: xl65, align: center"]25[/TD]
[TD="class: xl65, align: center"]From[/TD]
[TD="class: xl65, align: center"]To[/TD]
[TD="class: xl65, align: center"]Duration[/TD]
[TD="class: xl65, align: center"]From[/TD]
[TD="class: xl65, align: center"]To[/TD]
[TD="class: xl65, align: center"]Duration[/TD]
[TD="class: xl65, align: center"]Activity[/TD]
[TD="class: xl65, align: center"]Activity[/TD]
[TD="class: xl65, align: center"]Description[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]26[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl67, align: center"]9:03 AM[/TD]
[TD="class: xl66, align: center"]9:01 AM[/TD]
[TD="class: xl66, align: center"]00:01[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]NotReady / Pas Prêt[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]27[/TD]
[TD="class: xl66, align: center"]9:00 AM[/TD]
[TD="class: xl66, align: center"]10:30 AM[/TD]
[TD="class: xl66, align: center"]01:30[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Open/Ouvert[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]28[/TD]
[TD="class: xl66, align: center"]10:30 AM[/TD]
[TD="class: xl66, align: center"]10:45 AM[/TD]
[TD="class: xl66, align: center"]00:15[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Break/Pause[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]29[/TD]
[TD="class: xl66, align: center"]10:45 AM[/TD]
[TD="class: xl66, align: center"]12:15 PM[/TD]
[TD="class: xl66, align: center"]01:30[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Open/Ouvert[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]30[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]11:20 AM[/TD]
[TD="class: xl66, align: center"]11:35 AM[/TD]
[TD="class: xl66, align: center"]00:15[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]SignOff[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]31[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]12:02 PM[/TD]
[TD="class: xl66, align: center"]12:08 PM[/TD]
[TD="class: xl66, align: center"]00:06[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]NotReady / Pas Prêt[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]32[/TD]
[TD="class: xl66, align: center"]12:15 PM[/TD]
[TD="class: xl66, align: center"]12:45 PM[/TD]
[TD="class: xl66, align: center"]00:30[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Lunch/Repas[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]33[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]12:31 PM[/TD]
[TD="class: xl66, align: center"]1:01 PM[/TD]
[TD="class: xl66, align: center"]00:30[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]SignOff[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]34[/TD]
[TD="class: xl66, align: center"]12:45 PM[/TD]
[TD="class: xl66, align: center"]2:30 PM[/TD]
[TD="class: xl66, align: center"]01:45[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Open/Ouvert[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]35[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]1:01 PM[/TD]
[TD="class: xl66, align: center"]1:03 PM[/TD]
[TD="class: xl66, align: center"]00:02[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]NotReady / Pas Prêt[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]36[/TD]
[TD="class: xl66, align: center"]2:30 PM[/TD]
[TD="class: xl66, align: center"]2:45 PM[/TD]
[TD="class: xl66, align: center"]00:15[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Break/Pause[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]37[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]2:45 PM[/TD]
[TD="class: xl66, align: center"]3:00 PM[/TD]
[TD="class: xl66, align: center"]00:15[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]SignOff[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]38[/TD]
[TD="class: xl66, align: center"]2:45 PM[/TD]
[TD="class: xl66, align: center"]5:00 PM[/TD]
[TD="class: xl66, align: center"]02:15[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl69, width: 64, align: center"]Open/Ouvert[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl68, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl66, align: center"]39[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]--:--[/TD]
[TD="class: xl66, align: center"]3:18 PM[/TD]
[TD="class: xl66, align: center"]3:23 PM[/TD]
[TD="class: xl66, align: center"]00:05[/TD]
[TD="class: xl68, align: center"][/TD]
[TD="class: xl69, width: 64, align: center"]NotReady / Pas Prêt[/TD]
[TD="class: xl69, width: 64, align: center"]Unscheduled Event[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
row 5 from to is negative
ignoring that what is the question - for jane doe - total scheduled activity ? discrepancy ? number of activities ?
 
Upvote 0
I would like to create a Macro, or use formula's within Sheet2. This will pull the required data from Sheet1 and populate them into Sheet2. The data pulled are:

- Date:
  • There may be one or multiple dates in question.
  • The format of the date cell in Sheet1 will be the same ('Date: 1/01/15').
- Agent Name:
  • Agent Names and the number of agents listed will vary all the time.
  • The format will remain the same ('Agent: Jane Doe').
- Scheduled Start Time:
  • Cell location will vary, also will need to pull start time for each agent in Sheet1.
  • Will always be in Col. A.
  • Will always be the first time-stamp for each agent.
- Actual Start Time:
  • Cell location will vary, also will need to pull start time for each agent in Sheet1.
  • Will always be in Col. D.
  • Will always be the first time-stamp for each agent.


So, From Sheet1, it will recognize the date(s) available, and populate in the appropriate row in Sheet2 under date. The agent names will pull from Sheet1 and populate on the appropriate row in Sheet2 without duplicating names. Same with Schedules/Actual Start Times.
 
Upvote 0
Cell location will vary,

do you mean there will be a varying number of blank cells above it

for each name you want all the planned starts and actual starts ?
 
Upvote 0
correct, for each agent name, I would like to find and extract the planned and actual start times. The data will be extracted/duplicated onto my 2nd sheet under the respective headings. When I say cell location may vary, it is that the data within each cell will not be in the same location all the time (ie. 2nd agent's name may not always be in A22 // Planned/Actual start times may not always be in the same cells (will always be in the same column, but the rows may vary).

I am hoping there is a formula, that I can use on Sheet2, that will search and find the key data (agent name, date, etc). The roadblock i'm running into is that v or hlookup, as well as index/match won't work (to my knowledge) because of the way the data is presented in Sheet1.

I hope this clarifies a bit more - can what I'm looking to do be done?

Thank you again!
 
Upvote 0
[TABLE="width: 1216"]
<colgroup><col span="19"></colgroup><tbody>[TR]
[TD][/TD]
[TD="colspan: 2"]FOR AGENT 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 7"]I have concatenated every possible cell in C column (start pl) and in col G[/TD]
[TD]09:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]09:15[/TD]
[TD][/TD]
[TD="colspan: 4"]you can now work with these dates[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]by bringing over either a blank or a time in text format ("hh:mm")[/TD]
[TD][/TD]
[TD]11:30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11:35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"]see cells marked ######[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16:06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]as all the times are hh:mm easy to split them up again[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]agent1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]#########[/TD]
[TD][/TD]
[TD][/TD]
[TD]########[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]start pl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]start act[/TD]
[TD][/TD]
[TD="colspan: 2"]09:0011:3016:00[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]09:1511:3516:06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]NOTE I HAVE PUT DATES[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]ON DIFFERENT ROWS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]09:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]09:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]09:15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]09:15[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]AND THE THIRD ACT START DATE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]IS ABOVE THE CORRESPONDING[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 3"]PLANNED START DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11:30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11:35[/TD]
[TD][/TD]
[TD]11:30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]11:35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16:06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16:06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]agent2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]10:06[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12:02[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14:00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14:05[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16:10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16:15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Possible to pull apart 1st section of string for date & time
2 3
Replies
23
Views
437
Peter_SSs
Peter_SSs
J
  • Question Question
Finding Numbers from a Column Using Target Numbers
2
Replies
11
Views
414
Cubist
Cubist
A
  • Question Question
Get enddatetime if X no. of working hours is added to startdatetime
Replies
1
Views
430
myall_blues
myall_blues
J
  • Question Question
XLOOKUP, Finding a Value based on Time and Date
Replies
1
Views
302
SunnyAlv
SunnyAlv
Z
  • Solved
Formula to find 'Part of the Day' from the Time Column
Replies
8
Views
589
Zee996
Z

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top