Inserting a row inbetween consecutive conditions - Need Help VBA

[CoraG]

I am having difficulty a code that provides for inserting a row when there are to FALSE that fall consecutively. I would like to insert a row when this shows up. Do I use AND IF statement? The True/False column is M on my spreadsheet.

Lastrow = Worksheets("APR ADJ").Cells(Rows.Count, 12).End(xlUp).Row
For i = Lastrow To 2 Step by - 1

If Worksheets("APR ADJ").Cells(i, 12).Value = "FALSE FALSE" Then
ActiveCell.EntireRow.Insert Shift:=xlDown
End If
Next
Worksheets("APR ADJ").Cells(1, 1).Select

 

[Joe4]

But, if I am understanding your correctly, those values in columns A-I (except for column C), should match the value of the row above, should they not?
If not, can you provide an example where it does not (because then I am really lost in regards to where we are supposed to get the values from A-I).

 

[CoraG]

Te reason I ask if this can be done by CC From or CC To per date Column 8 is that the account/sub act/project number;task number can be different as reflected in this data set.

1	2	3	Account	Sub Act	PROJECT_NUMBER	TASK_NUMBER	EXP_ITEM_DATE	EXP_END_DATE
4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018
4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30061000	4/10/2018	4/15/2018
4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30111000	4/10/2018	4/15/2018
4879	Hudson	CC To	YN0100000	5Y110B	X5D100	0010AX33	4/10/2018	4/15/2018
4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018
4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011BHRL	4/11/2018	4/15/2018
4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018

<colgroup><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[CoraG]

The reason I ask is that the CC From and CC To can have difference account/sub act/project code/task information per date. Like the following transaction

1	2	3	Account	Sub Act	PROJECT_NUMBER	TASK_NUMBER	EXP_ITEM_DATE	EXP_END_DATE
4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018
4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30061000	4/10/2018	4/15/2018
4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30111000	4/10/2018	4/15/2018
4879	Hudson	CC To	YN0100000	5Y110B	X5D100	0010AX33	4/10/2018	4/15/2018
4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018
4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011BHRL	4/11/2018	4/15/2018
4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018

<colgroup><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[Joe4]

I do not understand what you are saying. Member, while this is very familiar to you because it is your project, it is not to us. All that we have to go on is what you explain in this ticket, and if that explanation is not clear to us, they we are kind of lost.

I think you best bet is to actual walk us through the details of one of your examples, where you tells us EXACTLY where the line is inserted, and a detailed explanation (in relation to the example) EXACTLY where the information that we are populating that inserted line comes from.

You posted some data examples above, but haven't walked us through the detailed explanation as it pertains to that particular example.

 

[CoraG]

Hello - I apologize for the lack of articulating what I am working on. So, I will do my best to give you the details all in this message and then you can see how best I should approach this. Maybe the True/False column is the wrong approach.
So here is a sample of employee data ID and EE are fictitious for obvious reasons. The data reflects when an employee changed their time card to different codes (account, sub act, project, or task) data or in other cases where you see from/to codes the same it indicates the only change is either decreasing/increasing hours worked.
I am working with 20,000+ rows of data all sorted by ID, Date, From/To. Column J Identifies where a different employee’s data starts and when the From/To format changes to, “From From,” or “To To,” by date for that employee.
It may take me several messages for you to see the example step by step to the final product.

									=IF(A2=A3,AND(C2<>C3))
	A	B	C	D	E	F	G	H	I	J
1	E ID	EE	FR/TO	Account	Sub Act	PROJECT_NUMBER	TASK_NUMBER	EXP_ITEM_DATE	EXP_END_DATE	True/False
2	4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018	TRUE
3	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30061000	4/10/2018	4/15/2018	TRUE
4	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30111000	4/10/2018	4/15/2018	FALSE
5	4879	Hudson	CC To	YN0100000	5Y110B	X5D100	0010AX33	4/10/2018	4/15/2018	TRUE
6	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
7	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011BHRL	4/11/2018	4/15/2018	TRUE
8	4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
9	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018	TRUE
10	7445	Scott	CC To	YN0100000	4R500A	SWDP00	70WQMA00	4/5/2018	4/8/2018	FALSE
11	7445	Scott	CC To	YN0100000	4R500A	X7CE00	PUTMANAL	4/5/2018	4/8/2018	FALSE
12	7445	Scott	CC To	YN0100000	4R500A	XE4500	ELECTEAM	4/5/2018	4/8/2018	FALSE
13	7445	Scott	CC To	YN0100000	4R500A	XUEP00	7JE80213	4/5/2018	4/8/2018	TRUE
14	7445	Scott	CC From	YN0100000	4R500A	XE4500	ELECTEAM	4/6/2018	4/8/2018	TRUE
15	7445	Scott	CC To	YN0100000	4R500A	XE4525	ELECTEBN	4/6/2018	4/8/2018	FALSE
16	8335	Allen	CC From	GD6030300	5J880A	HG5500	00000000	2/15/2018	2/18/2018	FALSE
17	8335	Allen	CC From	GD6030300	5J880A	HG5600	00000000	2/15/2018	2/18/2018	TRUE
18	8335	Allen	CC To	450140300	5J880A	RTBL00	00000000	2/15/2018	2/18/2018	FALSE

<colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[CoraG]

Step 1 – Insert the rows where they need to be. In this case the rows should be inserted
After 3, After 4, After 6, After 10, After 11, After 12, and After 16

	A	B	C	D	E	F	G	H	I	J
1	E ID	EE	FR/TO	Account	Sub Act	PROJECT_NUMBER	TASK_NUMBER	EXP_ITEM_DATE	EXP_END_DATE	True/False
2	4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018	TRUE
3	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30061000	4/10/2018	4/15/2018	TRUE
4	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30111000	4/10/2018	4/15/2018	FALSE
5	4879	Hudson	CC To	YN0100000	5Y110B	X5D100	0010AX33	4/10/2018	4/15/2018	TRUE
6	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
7	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011BHRL	4/11/2018	4/15/2018	TRUE
8	4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
9	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018	TRUE
10	7445	Scott	CC To	YN0100000	4R500A	SWDP00	70WQMA00	4/5/2018	4/8/2018	FALSE
11	7445	Scott	CC To	YN0100000	4R500A	X7CE00	PUTMANAL	4/5/2018	4/8/2018	FALSE
12	7445	Scott	CC To	YN0100000	4R500A	XE4500	ELECTEAM	4/5/2018	4/8/2018	FALSE
13	7445	Scott	CC To	YN0100000	4R500A	XUEP00	7JE80213	4/5/2018	4/8/2018	TRUE
14	7445	Scott	CC From	YN0100000	4R500A	XE4500	ELECTEAM	4/6/2018	4/8/2018	TRUE
15	7445	Scott	CC To	YN0100000	4R500A	XE4525	ELECTEBN	4/6/2018	4/8/2018	FALSE
16	8335	Allen	CC From	GD6030300	5J880A	HG5500	00000000	2/15/2018	2/18/2018	FALSE
17	8335	Allen	CC From	GD6030300	5J880A	HG5600	00000000	2/15/2018	2/18/2018	TRUE
18	8335	Allen	CC To	450140300	5J880A	RTBL00	00000000	2/15/2018	2/18/2018	FALSE

<colgroup><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Step 2 – Copy the data to the inserted rows
Copy Line 2 Data – To the blank row after 3, after, 4 (This is copying From data)
Copy Line 8 Data – To the blank row after 6 (This is copying To data)
Copy Line 9 Data – To the bank row after10, after 11, after 12 (This is copying From data)
Copy Line 18 Data – To the blank row after 16 (This is copying To data)

	A	B	C	D	E	F	G	H	I	J
1	E ID	EE	FR/TO	Account	Sub Act	PROJECT_NUMBER	TASK_NUMBER	EXP_ITEM_DATE	EXP_END_DATE	True/False
2	4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018	TRUE
3	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30061000	4/10/2018	4/15/2018	TRUE
COPY LINE 2 DATA
4	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30111000	4/10/2018	4/15/2018	FALSE
COPY LINE 2 DATA
5	4879	Hudson	CC To	YN0100000	5Y110B	X5D100	0010AX33	4/10/2018	4/15/2018	TRUE
6	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
COPY LINE 8 DATA
7	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011BHRL	4/11/2018	4/15/2018	TRUE
8	4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
9	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018	TRUE
10	7445	Scott	CC To	YN0100000	4R500A	SWDP00	70WQMA00	4/5/2018	4/8/2018	FALSE
COPY LINE 9 DATA
11	7445	Scott	CC To	YN0100000	4R500A	X7CE00	PUTMANAL	4/5/2018	4/8/2018	FALSE
COPY LINE 9 DATA
12	7445	Scott	CC To	YN0100000	4R500A	XE4500	ELECTEAM	4/5/2018	4/8/2018	FALSE
COPY LINE 9 DATA
13	7445	Scott	CC To	YN0100000	4R500A	XUEP00	7JE80213	4/5/2018	4/8/2018	TRUE
14	7445	Scott	CC From	YN0100000	4R500A	XE4500	ELECTEAM	4/6/2018	4/8/2018	TRUE
15	7445	Scott	CC To	YN0100000	4R500A	XE4525	ELECTEBN	4/6/2018	4/8/2018	FALSE
16	8335	Allen	CC From	GD6030300	5J880A	HG5500	00000000	2/15/2018	2/18/2018	FALSE
COPY LINE 18 DATA
17	8335	Allen	CC From	GD6030300	5J880A	HG5600	00000000	2/15/2018	2/18/2018	TRUE
18	8335	Allen	CC To	450140300	5J880A	RTBL00	00000000	2/15/2018	2/18/2018	FALSE

<colgroup><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[CoraG]

Step 1 – Insert the rows where they need to be. In this case the rows should be inserted
After 3, After 4, After 6, After 10, After 11, After 12, and After16

	A	B	C	D	E	F	G	H	I	J
1	E ID	EE	FR/TO	Account	Sub Act	PROJECT_NUMBER	TASK_NUMBER	EXP_ITEM_DATE	EXP_END_DATE	True/False
2	4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018	TRUE
3	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30061000	4/10/2018	4/15/2018	TRUE
4	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30111000	4/10/2018	4/15/2018	FALSE
5	4879	Hudson	CC To	YN0100000	5Y110B	X5D100	0010AX33	4/10/2018	4/15/2018	TRUE
6	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
7	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011BHRL	4/11/2018	4/15/2018	TRUE
8	4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
9	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018	TRUE
10	7445	Scott	CC To	YN0100000	4R500A	SWDP00	70WQMA00	4/5/2018	4/8/2018	FALSE
11	7445	Scott	CC To	YN0100000	4R500A	X7CE00	PUTMANAL	4/5/2018	4/8/2018	FALSE
12	7445	Scott	CC To	YN0100000	4R500A	XE4500	ELECTEAM	4/5/2018	4/8/2018	FALSE
13	7445	Scott	CC To	YN0100000	4R500A	XUEP00	7JE80213	4/5/2018	4/8/2018	TRUE
14	7445	Scott	CC From	YN0100000	4R500A	XE4500	ELECTEAM	4/6/2018	4/8/2018	TRUE
15	7445	Scott	CC To	YN0100000	4R500A	XE4525	ELECTEBN	4/6/2018	4/8/2018	FALSE
16	8335	Allen	CC From	GD6030300	5J880A	HG5500	00000000	2/15/2018	2/18/2018	FALSE
17	8335	Allen	CC From	GD6030300	5J880A	HG5600	00000000	2/15/2018	2/18/2018	TRUE
18	8335	Allen	CC To	450140300	5J880A	RTBL00	00000000	2/15/2018	2/18/2018	FALSE

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2986;width:63pt" width="84"> <col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:2702;width:57pt" width="76"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3015;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:2730;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:3157;width:67pt" width="89"> <col style="mso-width-source:userset;mso-width-alt:2844;width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:2901;width:61pt" width="82"> </colgroup><tbody>
</tbody>

Step 2 – Copy the data to the inserted rows
Copy Line 2 Data – To the blank row after 3, after, 4 (This is copying From data)
Copy Line 8 Data – To the blank row after 6 (This is copying To data)
Copy Line 9 Data – To the bank row after10, after 11, after 12 (This is copying From data)
Copy Line 18 Data – To the blank row after 16 (This is copying To data)

	A	B	C	D	E	F	G	H	I	J
1	E ID	EE	FR/TO	Account	Sub Act	PROJECT_NUMBER	TASK_NUMBER	EXP_ITEM_DATE	EXP_END_DATE	True/False
2	4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018	TRUE
3	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30061000	4/10/2018	4/15/2018	TRUE
COPY LINE 2 DATA
4	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30111000	4/10/2018	4/15/2018	FALSE
COPY LINE 2 DATA
5	4879	Hudson	CC To	YN0100000	5Y110B	X5D100	0010AX33	4/10/2018	4/15/2018	TRUE
6	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
COPY LINE 8 DATA
7	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011BHRL	4/11/2018	4/15/2018	TRUE
8	4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
9	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018	TRUE
10	7445	Scott	CC To	YN0100000	4R500A	SWDP00	70WQMA00	4/5/2018	4/8/2018	FALSE
COPY LINE 9 DATA
11	7445	Scott	CC To	YN0100000	4R500A	X7CE00	PUTMANAL	4/5/2018	4/8/2018	FALSE
COPY LINE 9 DATA
12	7445	Scott	CC To	YN0100000	4R500A	XE4500	ELECTEAM	4/5/2018	4/8/2018	FALSE
COPY LINE 9 DATA
13	7445	Scott	CC To	YN0100000	4R500A	XUEP00	7JE80213	4/5/2018	4/8/2018	TRUE
14	7445	Scott	CC From	YN0100000	4R500A	XE4500	ELECTEAM	4/6/2018	4/8/2018	TRUE
15	7445	Scott	CC To	YN0100000	4R500A	XE4525	ELECTEBN	4/6/2018	4/8/2018	FALSE
16	8335	Allen	CC From	GD6030300	5J880A	HG5500	00000000	2/15/2018	2/18/2018	FALSE
COPY LINE 18 DATA
17	8335	Allen	CC From	GD6030300	5J880A	HG5600	00000000	2/15/2018	2/18/2018	TRUE
18	8335	Allen	CC To	450140300	5J880A	RTBL00	00000000	2/15/2018	2/18/2018	FALSE

<colgroup><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[CoraG]

This is the final product

	A	B	C	D	E	F	G	H	I	J
1	E ID	EE	FR/TO	Account	Sub Act	PROJECT_NUMBER	TASK_NUMBER	EXP_ITEM_DATE	EXP_END_DATE	True/False
2	4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018	TRUE
3	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30061000	4/10/2018	4/15/2018	TRUE
	4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018
4	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30111000	4/10/2018	4/15/2018	FALSE
	4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018
5	4879	Hudson	CC To	YN0100000	5Y110B	X5D100	0010AX33	4/10/2018	4/15/2018	TRUE
6	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
	4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018
7	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011BHRL	4/11/2018	4/15/2018	TRUE
8	4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018	FALSE
9	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018	TRUE
10	7445	Scott	CC To	YN0100000	4R500A	SWDP00	70WQMA00	4/5/2018	4/8/2018	FALSE
	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018
11	7445	Scott	CC To	YN0100000	4R500A	X7CE00	PUTMANAL	4/5/2018	4/8/2018	FALSE
	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018
12	7445	Scott	CC To	YN0100000	4R500A	XE4500	ELECTEAM	4/5/2018	4/8/2018	FALSE
	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018
13	7445	Scott	CC To	YN0100000	4R500A	XUEP00	7JE80213	4/5/2018	4/8/2018	TRUE
14	7445	Scott	CC From	YN0100000	4R500A	XE4500	ELECTEAM	4/6/2018	4/8/2018	TRUE
15	7445	Scott	CC To	YN0100000	4R500A	XE4525	ELECTEBN	4/6/2018	4/8/2018	FALSE
16	8335	Allen	CC From	GD6030300	5J880A	HG5500	00000000	2/15/2018	2/18/2018	FALSE
	8335	Allen	CC To	450140300	5J880A	RTBL00	00000000	2/15/2018	2/18/2018
17	8335	Allen	CC From	GD6030300	5J880A	HG5600	00000000	2/15/2018	2/18/2018	TRUE
18	8335	Allen	CC To	450140300	5J880A	RTBL00	00000000	2/15/2018	2/18/2018	FALSE

<colgroup><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Joe4]

Step 1 – Insert the rows where they need to be. In this case the rows should be inserted
After 3, After 4, After 6, After 10, After 11, After 12, and After 16

OK, it appears that these seem to keep changing on-the-fly here making things very confusing.
Originally, we were looking at the TRUE/FALSE values in column M, but it appears that has now shifted to to column J.
More concerning that is that the whole original code was predicated on the condition of inserting lines between two FALSE values in the last column.
But where you are saying to insert lines no longer seems to follow that rule (i.e. you say insert lines after lines 3, 4, and 6, but there are not two consecutive FALSE statements in any of those lines).

It is really hard to build off the code we have already done if the original conditions we programmed to keep changing.

Also, be careful not to fall into the trap many noobs fall into, that can cause a lot of heartache for both you and the respondents - don't oversimplify your question to the point where the answer does not solve your problem. Otherwise, you get solutions that only do part of what you want, or don't work for your situation at all (i.e. your original post was just asking for a blank line insert, but you really wanted much more than that). Better to lay it all out there right away so we have a better idea on what the scope is and can plan how to attack it accordingly.

 

[CoraG]

Hello Joe - Thank you for your response. Forget about the True/False Column. Given the information I have provided E_ID, EXP_ITEM_DATE, the consecutive condition is Column C (FR/TO). You asked that I outline EXACTLY details of the project. Step 1 - A row should be inserted after 3, 4, 6, 10,11, 12, and 16

1	E ID	EE	FR/TO	Account	Sub Act	PROJECT_NUMBER	TASK_NUMBER	EXP_ITEM_DATE	EXP_END_DATE
2	4879	Hudson	CC From	MB0502000	5Y110B	KK0100	30060000	4/10/2018	4/15/2018
3	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30061000	4/10/2018	4/15/2018
4	4879	Hudson	CC To	MB0502000	5Y110B	KKEQ00	30111000	4/10/2018	4/15/2018
5	4879	Hudson	CC To	YN0100000	5Y110B	X5D100	0010AX33	4/10/2018	4/15/2018
6	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018
7	4879	Hudson	CC From	YN0100000	3B100A	XA3100	0011BHRL	4/11/2018	4/15/2018
8	4879	Hudson	CC To	YN0100000	3B100A	XA3100	0011B5L3	4/11/2018	4/15/2018
9	7445	Scott	CC From	YN0100000	4R500A	SWDP00	70WPM6RE	4/5/2018	4/8/2018
10	7445	Scott	CC To	YN0100000	4R500A	SWDP00	70WQMA00	4/5/2018	4/8/2018
11	7445	Scott	CC To	YN0100000	4R500A	X7CE00	PUTMANAL	4/5/2018	4/8/2018
12	7445	Scott	CC To	YN0100000	4R500A	XE4500	ELECTEAM	4/5/2018	4/8/2018
13	7445	Scott	CC To	YN0100000	4R500A	XUEP00	7JE80213	4/5/2018	4/8/2018
14	7445	Scott	CC From	YN0100000	4R500A	XE4500	ELECTEAM	4/6/2018	4/8/2018
15	7445	Scott	CC To	YN0100000	4R500A	XE4525	ELECTEBN	4/6/2018	4/8/2018
16	8335	Allen	CC From	GD6030300	5J880A	HG5500	00000000	2/15/2018	2/18/2018
17	8335	Allen	CC From	GD6030300	5J880A	HG5600	00000000	2/15/2018	2/18/2018
18	8335	Allen	CC To	450140300	5J880A	RTBL00	00000000	2/15/2018	2/18/2018

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2986;width:63pt" width="84"> <col style="width:48pt" span="2" width="64"> <col style="mso-width-source:userset;mso-width-alt:2702;width:57pt" width="76"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3015;width:64pt" width="85"> <col style="mso-width-source:userset;mso-width-alt:2730;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:3157;width:67pt" width="89"> <col style="mso-width-source:userset;mso-width-alt:2844;width:60pt" width="80"> </colgroup><tbody>
</tbody>