JSR1306
New Member
- Joined
- Sep 15, 2012
- Messages
- 45
Hello,
Hopefully one of you VBA whizzes will be able to solve my problem
I have a table of data (See below) that I need to extract data from based on the unique ID number and the time that the specific record breached the SLA due date.
For example: record ID 196664 was due by 30/01/13 at 17:57:00 - The first row that goes past this date and time is row 6 with a date and time of 01/02/13 at 09:34:42. This is then the row I want to copy and paste into a new sheet.
All breaching date times after the first one are not required, I only want to return the first one that breaches SLA Due date.
<tbody>
</tbody>
I appreciate any help.
Many Thanks
John
Hopefully one of you VBA whizzes will be able to solve my problem
I have a table of data (See below) that I need to extract data from based on the unique ID number and the time that the specific record breached the SLA due date.
For example: record ID 196664 was due by 30/01/13 at 17:57:00 - The first row that goes past this date and time is row 6 with a date and time of 01/02/13 at 09:34:42. This is then the row I want to copy and paste into a new sheet.
All breaching date times after the first one are not required, I only want to return the first one that breaches SLA Due date.
incident_no | priority | sla_due_date | sla_due_time | status | date_last_updated | time_last_updated | old_status | new_status | date_updated | time_updated |
196664 | 4 | 30/01/2013 | 17:57:00 | Closed | 01/02/2013 | 09:34:40 | Await Cust 1 | Await Cust 2 | 27/01/2013 | 11:50:44 |
196664 | 4 | 30/01/2013 | 17:57:00 | Closed | 01/02/2013 | 09:34:40 | Await Cust 1 | Await Cust 2 | 28/01/2013 | 17:55:31 |
196664 | 4 | 30/01/2013 | 17:57:00 | Closed | 01/02/2013 | 09:34:40 | Await Cust 2 | Resolved | 29/01/2013 | 13:52:17 |
196664 | 4 | 30/01/2013 | 17:57:00 | Closed | 01/02/2013 | 09:34:40 | Resolved | Escalated to 3rd Party | 29/01/2013 | 13:57:07 |
196664 | 4 | 30/01/2013 | 17:57:00 | Closed | 01/02/2013 | 09:34:40 | Escalated to 3rd Party | Closed | 01/02/2013 | 09:34:42 |
196664 | 4 | 30/01/2013 | 17:57:00 | Closed | 01/02/2013 | 09:34:40 | Await Cust 2 | Await Cust 1 | 28/01/2013 | 09:20:29 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Open | Await Cust 1 | 21/01/2013 | 14:00:05 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Escalated to 3rd Party | Closed | 01/02/2013 | 10:25:41 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Open | Escalated to 3rd Party | 31/01/2013 | 11:42:50 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Await Cust 2 | Escalated to 2nd Line | 29/01/2013 | 16:11:30 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Escalated to 3rd Party | Open | 31/01/2013 | 09:55:53 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Await Cust 1 | Await Cust 2 | 23/01/2013 | 17:57:18 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Escalated to 2nd Line | Open | 30/01/2013 | 14:27:12 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Open | Escalated to 3rd Party | 31/01/2013 | 08:26:22 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Open | Escalated to 3rd Party | 30/01/2013 | 16:24:21 |
194531 | 4 | 30/01/2013 | 15:43:00 | Closed | 01/02/2013 | 10:45:03 | Escalated to 3rd Party | Open | 30/01/2013 | 16:50:42 |
191877 | 4 | 16/01/2013 | 11:24:00 | Closed | 01/02/2013 | 10:55:05 | Escalated to 3rd Line | Passed Back | 25/01/2013 | 13:43:33 |
191877 | 4 | 16/01/2013 | 11:24:00 | Closed | 01/02/2013 | 10:55:05 | Await Cust 1 | Await Cust 2 | 14/01/2013 | 10:40:00 |
191877 | 4 | 16/01/2013 | 11:24:00 | Closed | 01/02/2013 | 10:55:05 | Passed Back | Escalated to 3rd Line | 25/01/2013 | 11:15:01 |
191877 | 4 | 16/01/2013 | 11:24:00 | Closed | 01/02/2013 | 10:55:05 | Await Cust 2 | Escalated to 2nd Line | 15/01/2013 | 11:40:54 |
191877 | 4 | 16/01/2013 | 11:24:00 | Closed | 01/02/2013 | 10:55:05 | Passed Back | Closed | 01/02/2013 | 10:55:11 |
191877 | 4 | 16/01/2013 | 11:24:00 | Closed | 01/02/2013 | 10:55:05 | Open | Await Cust 1 | 12/01/2013 | 10:17:54 |
191877 | 4 | 16/01/2013 | 11:24:00 | Closed | 01/02/2013 | 10:55:05 | Escalated to 2nd Line | Escalated to 3rd Line | 16/01/2013 | 10:46:22 |
191877 | 4 | 16/01/2013 | 11:24:00 | Closed | 01/02/2013 | 10:55:05 | Escalated to 3rd Line | Passed Back | 19/01/2013 | 09:10:03 |
<tbody>
</tbody>
I appreciate any help.
Many Thanks
John