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!
 
Sort by date Sort by votes
Thanks oldbrewer - unfortunately with the formatting in the response, I don't follow what the solution is. Is there a macro/formula you've used?

Thanks
 
Upvote 0
can you not see that I have concatenated every cell in the time column
so if there were only 2 times 08:15 and 11:20 separated by 5 empty cells the result would be 08:1511:20

I then split that back into 2 times giving me the ONLY planned start times

have another look at my post
 
Upvote 0
Thanks, but that does not achieve what I am trying to do. The main sheet will be Sheet2. I want to display data on Sheet2, using info from Sheet1. Is there a formula that I would use to do this?
 
Upvote 0
I am suggesting an approach - change the cell references to sheet1!A1 etc etc

My approach puts all the times in individual cells that you can compare- all the work can be done on sheet 1 and the lists of times, or just the discrepancies, can go on sheet 2
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
TIME LIMITATIONS
Replies
1
Views
226
cooleomter
C
S
  • Question Question
VBA Separate Day and Time to Another Column if condition meet
2
Replies
10
Views
165
SamKhem
S
P
  • Question Question
Generating an an excel report from data sheet
2
Replies
10
Views
264
alansidman
alansidman
V
  • Question Question
time and date fix
Replies
7
Views
187
vmjan02
V
B
  • Solved
Possible to pull apart 1st section of string for date & time
2 3
Replies
23
Views
803
Peter_SSs
Peter_SSs

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