Inserting a row inbetween consecutive conditions - Need Help VBA

C

CoraG

New Member
Joined
Aug 30, 2018
Messages
31
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
 
Sort by date Sort by votes
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).
 
Upvote 0

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
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.
[TABLE="width: 700"]
<colgroup><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]Account[/TD]
[TD]Sub Act[/TD]
[TD]PROJECT_NUMBER[/TD]
[TD]TASK_NUMBER[/TD]
[TD]EXP_ITEM_DATE[/TD]
[TD]EXP_END_DATE[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KK0100[/TD]
[TD]30060000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30061000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30111000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]5Y110B[/TD]
[TD]X5D100[/TD]
[TD]0010AX33[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011BHRL[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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

[TABLE="width: 700"]
<colgroup><col><col><col><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]Account[/TD]
[TD]Sub Act[/TD]
[TD]PROJECT_NUMBER[/TD]
[TD]TASK_NUMBER[/TD]
[TD]EXP_ITEM_DATE[/TD]
[TD]EXP_END_DATE[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KK0100[/TD]
[TD]30060000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30061000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30111000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]5Y110B[/TD]
[TD]X5D100[/TD]
[TD]0010AX33[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011BHRL[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
[TR]
[TD="align: right"]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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.
 
Upvote 0
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.

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


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)

[TABLE="width: 829"]
<colgroup><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]E ID[/TD]
[TD]EE[/TD]
[TD]FR/TO[/TD]
[TD]Account[/TD]
[TD]Sub Act[/TD]
[TD]PROJECT_NUMBER[/TD]
[TD]TASK_NUMBER[/TD]
[TD]EXP_ITEM_DATE[/TD]
[TD]EXP_END_DATE[/TD]
[TD]True/False[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KK0100[/TD]
[TD]30060000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30061000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 2 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30111000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 2 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]5Y110B[/TD]
[TD]X5D100[/TD]
[TD]0010AX33[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 8 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011BHRL[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]SWDP00[/TD]
[TD]70WPM6RE[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]SWDP00[/TD]
[TD]70WQMA00[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 9 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]X7CE00[/TD]
[TD]PUTMANAL[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 9 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XE4500[/TD]
[TD]ELECTEAM[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 9 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XUEP00[/TD]
[TD]7JE80213[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XE4500[/TD]
[TD]ELECTEAM[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XE4525[/TD]
[TD]ELECTEBN[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC From[/TD]
[TD]GD6030300[/TD]
[TD]5J880A[/TD]
[TD]HG5500[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 18 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC From[/TD]
[TD]GD6030300[/TD]
[TD]5J880A[/TD]
[TD]HG5600[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC To[/TD]
[TD]450140300[/TD]
[TD]5J880A[/TD]
[TD]RTBL00[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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

<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>
[TD="width: 64"][/TD]
[TD="class: xl72, width: 84"]A[/TD]
[TD="class: xl72, width: 64"]B[/TD]
[TD="class: xl72, width: 64"]C[/TD]
[TD="class: xl72, width: 76"]D[/TD]
[TD="class: xl72, width: 64"]E[/TD]
[TD="class: xl72, width: 85"]F[/TD]
[TD="class: xl72, width: 77"]G[/TD]
[TD="class: xl72, width: 89"]H[/TD]
[TD="class: xl72, width: 80"]I[/TD]
[TD="class: xl72, width: 82"]J[/TD]

[TD="class: xl74"]1[/TD]
[TD="class: xl87, width: 84"]E ID[/TD]
[TD="class: xl87, width: 64"]EE[/TD]
[TD="class: xl87, width: 64"]FR/TO[/TD]
[TD="class: xl87, width: 76"]Account[/TD]
[TD="class: xl87, width: 64"]Sub Act[/TD]
[TD="class: xl87, width: 85"]PROJECT_NUMBER[/TD]
[TD="class: xl87, width: 77"]TASK_NUMBER[/TD]
[TD="class: xl87, width: 89"]EXP_ITEM_DATE[/TD]
[TD="class: xl87, width: 80"]EXP_END_DATE[/TD]
[TD="class: xl87, width: 82"]True/False[/TD]

[TD="class: xl74"]2[/TD]
[TD="class: xl76"]4879[/TD]
[TD="class: xl77"]Hudson[/TD]
[TD="class: xl77"]CC From[/TD]
[TD="class: xl77"]MB0502000[/TD]
[TD="class: xl77"]5Y110B[/TD]
[TD="class: xl77"]KK0100[/TD]
[TD="class: xl77"]30060000[/TD]
[TD="class: xl78, align: right"]4/10/2018[/TD]
[TD="class: xl79, align: right"]4/15/2018[/TD]
[TD="class: xl75, align: center"]TRUE[/TD]

[TD="class: xl82"]3[/TD]
[TD="class: xl80"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]MB0502000[/TD]
[TD="class: xl66"]5Y110B[/TD]
[TD="class: xl66"]KKEQ00[/TD]
[TD="class: xl66"]30061000[/TD]
[TD="class: xl67, align: right"]4/10/2018[/TD]
[TD="class: xl81, align: right"]4/15/2018[/TD]
[TD="class: xl75, align: center"]TRUE[/TD]

[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl83"]4[/TD]
[TD="class: xl69"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]MB0502000[/TD]
[TD="class: xl66"]5Y110B[/TD]
[TD="class: xl66"]KKEQ00[/TD]
[TD="class: xl66"]30111000[/TD]
[TD="class: xl67, align: right"]4/10/2018[/TD]
[TD="class: xl67, align: right"]4/15/2018[/TD]
[TD="class: xl68, align: center"]FALSE[/TD]

[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl69"]5[/TD]
[TD="class: xl69"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]5Y110B[/TD]
[TD="class: xl66"]X5D100[/TD]
[TD="class: xl66"]0010AX33[/TD]
[TD="class: xl67, align: right"]4/10/2018[/TD]
[TD="class: xl67, align: right"]4/15/2018[/TD]
[TD="class: xl66, align: center"]TRUE[/TD]

[TD="class: xl83"]6[/TD]
[TD="class: xl69"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC From[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]3B100A[/TD]
[TD="class: xl66"]XA3100[/TD]
[TD="class: xl66"]0011B5L3[/TD]
[TD="class: xl67, align: right"]4/11/2018[/TD]
[TD="class: xl67, align: right"]4/15/2018[/TD]
[TD="class: xl68, align: center"]FALSE[/TD]

[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl69"]7[/TD]
[TD="class: xl69"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC From[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]3B100A[/TD]
[TD="class: xl66"]XA3100[/TD]
[TD="class: xl66"]0011BHRL[/TD]
[TD="class: xl67, align: right"]4/11/2018[/TD]
[TD="class: xl67, align: right"]4/15/2018[/TD]
[TD="class: xl66, align: center"]TRUE[/TD]

[TD="class: xl69"]8[/TD]
[TD="class: xl73"]4879[/TD]
[TD="class: xl70"]Hudson[/TD]
[TD="class: xl70"]CC To[/TD]
[TD="class: xl70"]YN0100000[/TD]
[TD="class: xl70"]3B100A[/TD]
[TD="class: xl70"]XA3100[/TD]
[TD="class: xl70"]0011B5L3[/TD]
[TD="class: xl71, align: right"]4/11/2018[/TD]
[TD="class: xl71, align: right"]4/15/2018[/TD]
[TD="class: xl68, align: center"]FALSE[/TD]

[TD="class: xl69"]9[/TD]
[TD="class: xl73"]7445[/TD]
[TD="class: xl70"]Scott [/TD]
[TD="class: xl70"]CC From[/TD]
[TD="class: xl70"]YN0100000[/TD]
[TD="class: xl70"]4R500A[/TD]
[TD="class: xl70"]SWDP00[/TD]
[TD="class: xl70"]70WPM6RE[/TD]
[TD="class: xl71, align: right"]4/5/2018[/TD]
[TD="class: xl71, align: right"]4/8/2018[/TD]
[TD="class: xl66, align: center"]TRUE[/TD]

[TD="class: xl83"]10[/TD]
[TD="class: xl69"]7445[/TD]
[TD="class: xl66"]Scott [/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]4R500A[/TD]
[TD="class: xl66"]SWDP00[/TD]
[TD="class: xl66"]70WQMA00[/TD]
[TD="class: xl67, align: right"]4/5/2018[/TD]
[TD="class: xl67, align: right"]4/8/2018[/TD]
[TD="class: xl68, align: center"]FALSE[/TD]

[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl83"]11[/TD]
[TD="class: xl69"]7445[/TD]
[TD="class: xl66"]Scott [/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]4R500A[/TD]
[TD="class: xl66"]X7CE00[/TD]
[TD="class: xl66"]PUTMANAL[/TD]
[TD="class: xl67, align: right"]4/5/2018[/TD]
[TD="class: xl67, align: right"]4/8/2018[/TD]
[TD="class: xl68, align: center"]FALSE[/TD]

[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl83"]12[/TD]
[TD="class: xl69"]7445[/TD]
[TD="class: xl66"]Scott [/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]4R500A[/TD]
[TD="class: xl66"]XE4500[/TD]
[TD="class: xl66"]ELECTEAM[/TD]
[TD="class: xl67, align: right"]4/5/2018[/TD]
[TD="class: xl67, align: right"]4/8/2018[/TD]
[TD="class: xl68, align: center"]FALSE[/TD]

[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl73"]13[/TD]
[TD="class: xl69"]7445[/TD]
[TD="class: xl66"]Scott [/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]4R500A[/TD]
[TD="class: xl66"]XUEP00[/TD]
[TD="class: xl66"]7JE80213[/TD]
[TD="class: xl67, align: right"]4/5/2018[/TD]
[TD="class: xl67, align: right"]4/8/2018[/TD]
[TD="class: xl66, align: center"]TRUE[/TD]

[TD="class: xl69"]14[/TD]
[TD="class: xl84"]7445[/TD]
[TD="class: xl85"]Scott [/TD]
[TD="class: xl85"]CC From[/TD]
[TD="class: xl85"]YN0100000[/TD]
[TD="class: xl85"]4R500A[/TD]
[TD="class: xl85"]XE4500[/TD]
[TD="class: xl85"]ELECTEAM[/TD]
[TD="class: xl86, align: right"]4/6/2018[/TD]
[TD="class: xl86, align: right"]4/8/2018[/TD]
[TD="class: xl66, align: center"]TRUE[/TD]

[TD="class: xl69"]15[/TD]
[TD="class: xl84"]7445[/TD]
[TD="class: xl85"]Scott [/TD]
[TD="class: xl85"]CC To[/TD]
[TD="class: xl85"]YN0100000[/TD]
[TD="class: xl85"]4R500A[/TD]
[TD="class: xl85"]XE4525[/TD]
[TD="class: xl85"]ELECTEBN[/TD]
[TD="class: xl86, align: right"]4/6/2018[/TD]
[TD="class: xl86, align: right"]4/8/2018[/TD]
[TD="class: xl68, align: center"]FALSE[/TD]

[TD="class: xl83"]16[/TD]
[TD="class: xl69"]8335[/TD]
[TD="class: xl66"]Allen[/TD]
[TD="class: xl66"]CC From[/TD]
[TD="class: xl66"]GD6030300[/TD]
[TD="class: xl66"]5J880A[/TD]
[TD="class: xl66"]HG5500[/TD]
[TD="class: xl66"]00000000[/TD]
[TD="class: xl67, align: right"]2/15/2018[/TD]
[TD="class: xl67, align: right"]2/18/2018[/TD]
[TD="class: xl68, align: center"]FALSE[/TD]

[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl68"] [/TD]

[TD="class: xl69"]17[/TD]
[TD="class: xl69"]8335[/TD]
[TD="class: xl66"]Allen[/TD]
[TD="class: xl66"]CC From[/TD]
[TD="class: xl66"]GD6030300[/TD]
[TD="class: xl66"]5J880A[/TD]
[TD="class: xl66"]HG5600[/TD]
[TD="class: xl66"]00000000[/TD]
[TD="class: xl67, align: right"]2/15/2018[/TD]
[TD="class: xl67, align: right"]2/18/2018[/TD]
[TD="class: xl66, align: center"]TRUE[/TD]

[TD="class: xl69"]18
[/TD]
[TD="class: xl73"]8335[/TD]
[TD="class: xl70"]Allen[/TD]
[TD="class: xl70"]CC To[/TD]
[TD="class: xl70"]450140300[/TD]
[TD="class: xl70"]5J880A[/TD]
[TD="class: xl70"]RTBL00[/TD]
[TD="class: xl70"]00000000[/TD]
[TD="class: xl71, align: right"]2/15/2018[/TD]
[TD="class: xl71, align: right"]2/18/2018[/TD]
[TD="class: xl68, align: center"]FALSE



[/TD]

</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)

[TABLE="width: 829"]
<colgroup><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]E ID[/TD]
[TD]EE[/TD]
[TD]FR/TO[/TD]
[TD]Account[/TD]
[TD]Sub Act[/TD]
[TD]PROJECT_NUMBER[/TD]
[TD]TASK_NUMBER[/TD]
[TD]EXP_ITEM_DATE[/TD]
[TD]EXP_END_DATE[/TD]
[TD]True/False[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KK0100[/TD]
[TD]30060000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30061000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 2 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30111000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 2 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]5Y110B[/TD]
[TD]X5D100[/TD]
[TD]0010AX33[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 8 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011BHRL[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]SWDP00[/TD]
[TD]70WPM6RE[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]SWDP00[/TD]
[TD]70WQMA00[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 9 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]X7CE00[/TD]
[TD]PUTMANAL[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 9 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XE4500[/TD]
[TD]ELECTEAM[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 9 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XUEP00[/TD]
[TD]7JE80213[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XE4500[/TD]
[TD]ELECTEAM[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XE4525[/TD]
[TD]ELECTEBN[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC From[/TD]
[TD]GD6030300[/TD]
[TD]5J880A[/TD]
[TD]HG5500[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="colspan: 10"]COPY LINE 18 DATA[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC From[/TD]
[TD]GD6030300[/TD]
[TD]5J880A[/TD]
[TD]HG5600[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC To[/TD]
[TD]450140300[/TD]
[TD]5J880A[/TD]
[TD]RTBL00[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
This is the final product

[TABLE="width: 829"]
<colgroup><col><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]E ID[/TD]
[TD]EE[/TD]
[TD]FR/TO[/TD]
[TD]Account[/TD]
[TD]Sub Act[/TD]
[TD]PROJECT_NUMBER[/TD]
[TD]TASK_NUMBER[/TD]
[TD]EXP_ITEM_DATE[/TD]
[TD]EXP_END_DATE[/TD]
[TD]True/False[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KK0100[/TD]
[TD]30060000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30061000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KK0100[/TD]
[TD]30060000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KKEQ00[/TD]
[TD]30111000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]MB0502000[/TD]
[TD]5Y110B[/TD]
[TD]KK0100[/TD]
[TD]30060000[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]5Y110B[/TD]
[TD]X5D100[/TD]
[TD]0010AX33[/TD]
[TD="align: right"]4/10/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011BHRL[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]4879[/TD]
[TD]Hudson[/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]3B100A[/TD]
[TD]XA3100[/TD]
[TD]0011B5L3[/TD]
[TD="align: right"]4/11/2018[/TD]
[TD="align: right"]4/15/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]SWDP00[/TD]
[TD]70WPM6RE[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]SWDP00[/TD]
[TD]70WQMA00[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]SWDP00[/TD]
[TD]70WPM6RE[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]X7CE00[/TD]
[TD]PUTMANAL[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]SWDP00[/TD]
[TD]70WPM6RE[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XE4500[/TD]
[TD]ELECTEAM[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]SWDP00[/TD]
[TD]70WPM6RE[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XUEP00[/TD]
[TD]7JE80213[/TD]
[TD="align: right"]4/5/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC From[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XE4500[/TD]
[TD]ELECTEAM[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]7445[/TD]
[TD]Scott [/TD]
[TD]CC To[/TD]
[TD]YN0100000[/TD]
[TD]4R500A[/TD]
[TD]XE4525[/TD]
[TD]ELECTEBN[/TD]
[TD="align: right"]4/6/2018[/TD]
[TD="align: right"]4/8/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC From[/TD]
[TD]GD6030300[/TD]
[TD]5J880A[/TD]
[TD]HG5500[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC To[/TD]
[TD]450140300[/TD]
[TD]5J880A[/TD]
[TD]RTBL00[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC From[/TD]
[TD]GD6030300[/TD]
[TD]5J880A[/TD]
[TD]HG5600[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]8335[/TD]
[TD]Allen[/TD]
[TD]CC To[/TD]
[TD]450140300[/TD]
[TD]5J880A[/TD]
[TD]RTBL00[/TD]
[TD]00000000[/TD]
[TD="align: right"]2/15/2018[/TD]
[TD="align: right"]2/18/2018[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
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
Click to expand...
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.
 
Upvote 0
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



<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>
[TD="class: xl68, width: 64"]1[/TD]
[TD="class: xl76, width: 84"]E ID[/TD]
[TD="class: xl76, width: 64"]EE[/TD]
[TD="class: xl76, width: 64"]FR/TO[/TD]
[TD="class: xl76, width: 76"]Account[/TD]
[TD="class: xl76, width: 64"]Sub Act[/TD]
[TD="class: xl76, width: 85"]PROJECT_NUMBER[/TD]
[TD="class: xl76, width: 77"]TASK_NUMBER[/TD]
[TD="class: xl76, width: 89"]EXP_ITEM_DATE[/TD]
[TD="class: xl76, width: 80"]EXP_END_DATE[/TD]

[TD="class: xl68"]2[/TD]
[TD="class: xl71"]4879[/TD]
[TD="class: xl69"]Hudson[/TD]
[TD="class: xl69"]CC From[/TD]
[TD="class: xl69"]MB0502000[/TD]
[TD="class: xl69"]5Y110B[/TD]
[TD="class: xl69"]KK0100[/TD]
[TD="class: xl69"]30060000[/TD]
[TD="class: xl70, align: right"]4/10/2018[/TD]
[TD="class: xl70, align: right"]4/15/2018[/TD]

[TD="class: xl72"]3[/TD]
[TD="class: xl68"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]MB0502000[/TD]
[TD="class: xl66"]5Y110B[/TD]
[TD="class: xl66"]KKEQ00[/TD]
[TD="class: xl66"]30061000[/TD]
[TD="class: xl67, align: right"]4/10/2018[/TD]
[TD="class: xl67, align: right"]4/15/2018[/TD]

[TD="class: xl72"]4[/TD]
[TD="class: xl68"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]MB0502000[/TD]
[TD="class: xl66"]5Y110B[/TD]
[TD="class: xl66"]KKEQ00[/TD]
[TD="class: xl66"]30111000[/TD]
[TD="class: xl67, align: right"]4/10/2018[/TD]
[TD="class: xl67, align: right"]4/15/2018[/TD]

[TD="class: xl68"]5[/TD]
[TD="class: xl68"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]5Y110B[/TD]
[TD="class: xl66"]X5D100[/TD]
[TD="class: xl66"]0010AX33[/TD]
[TD="class: xl67, align: right"]4/10/2018[/TD]
[TD="class: xl67, align: right"]4/15/2018[/TD]

[TD="class: xl72"]6[/TD]
[TD="class: xl68"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC From[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]3B100A[/TD]
[TD="class: xl66"]XA3100[/TD]
[TD="class: xl66"]0011B5L3[/TD]
[TD="class: xl67, align: right"]4/11/2018[/TD]
[TD="class: xl67, align: right"]4/15/2018[/TD]

[TD="class: xl68"]7[/TD]
[TD="class: xl68"]4879[/TD]
[TD="class: xl66"]Hudson[/TD]
[TD="class: xl66"]CC From[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]3B100A[/TD]
[TD="class: xl66"]XA3100[/TD]
[TD="class: xl66"]0011BHRL[/TD]
[TD="class: xl67, align: right"]4/11/2018[/TD]
[TD="class: xl67, align: right"]4/15/2018[/TD]

[TD="class: xl68"]8[/TD]
[TD="class: xl71"]4879[/TD]
[TD="class: xl69"]Hudson[/TD]
[TD="class: xl69"]CC To[/TD]
[TD="class: xl69"]YN0100000[/TD]
[TD="class: xl69"]3B100A[/TD]
[TD="class: xl69"]XA3100[/TD]
[TD="class: xl69"]0011B5L3[/TD]
[TD="class: xl70, align: right"]4/11/2018[/TD]
[TD="class: xl70, align: right"]4/15/2018[/TD]

[TD="class: xl68"]9[/TD]
[TD="class: xl71"]7445[/TD]
[TD="class: xl69"]Scott [/TD]
[TD="class: xl69"]CC From[/TD]
[TD="class: xl69"]YN0100000[/TD]
[TD="class: xl69"]4R500A[/TD]
[TD="class: xl69"]SWDP00[/TD]
[TD="class: xl69"]70WPM6RE[/TD]
[TD="class: xl70, align: right"]4/5/2018[/TD]
[TD="class: xl70, align: right"]4/8/2018[/TD]

[TD="class: xl72"]10[/TD]
[TD="class: xl68"]7445[/TD]
[TD="class: xl66"]Scott [/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]4R500A[/TD]
[TD="class: xl66"]SWDP00[/TD]
[TD="class: xl66"]70WQMA00[/TD]
[TD="class: xl67, align: right"]4/5/2018[/TD]
[TD="class: xl67, align: right"]4/8/2018[/TD]

[TD="class: xl72"]11[/TD]
[TD="class: xl68"]7445[/TD]
[TD="class: xl66"]Scott [/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]4R500A[/TD]
[TD="class: xl66"]X7CE00[/TD]
[TD="class: xl66"]PUTMANAL[/TD]
[TD="class: xl67, align: right"]4/5/2018[/TD]
[TD="class: xl67, align: right"]4/8/2018[/TD]

[TD="class: xl72"]12[/TD]
[TD="class: xl68"]7445[/TD]
[TD="class: xl66"]Scott [/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]4R500A[/TD]
[TD="class: xl66"]XE4500[/TD]
[TD="class: xl66"]ELECTEAM[/TD]
[TD="class: xl67, align: right"]4/5/2018[/TD]
[TD="class: xl67, align: right"]4/8/2018[/TD]

[TD="class: xl68"]13[/TD]
[TD="class: xl68"]7445[/TD]
[TD="class: xl66"]Scott [/TD]
[TD="class: xl66"]CC To[/TD]
[TD="class: xl66"]YN0100000[/TD]
[TD="class: xl66"]4R500A[/TD]
[TD="class: xl66"]XUEP00[/TD]
[TD="class: xl66"]7JE80213[/TD]
[TD="class: xl67, align: right"]4/5/2018[/TD]
[TD="class: xl67, align: right"]4/8/2018[/TD]

[TD="class: xl68"]14[/TD]
[TD="class: xl73"]7445[/TD]
[TD="class: xl74"]Scott [/TD]
[TD="class: xl74"]CC From[/TD]
[TD="class: xl74"]YN0100000[/TD]
[TD="class: xl74"]4R500A[/TD]
[TD="class: xl74"]XE4500[/TD]
[TD="class: xl74"]ELECTEAM[/TD]
[TD="class: xl75, align: right"]4/6/2018[/TD]
[TD="class: xl75, align: right"]4/8/2018[/TD]

[TD="class: xl68"]15[/TD]
[TD="class: xl73"]7445[/TD]
[TD="class: xl74"]Scott [/TD]
[TD="class: xl74"]CC To[/TD]
[TD="class: xl74"]YN0100000[/TD]
[TD="class: xl74"]4R500A[/TD]
[TD="class: xl74"]XE4525[/TD]
[TD="class: xl74"]ELECTEBN[/TD]
[TD="class: xl75, align: right"]4/6/2018[/TD]
[TD="class: xl75, align: right"]4/8/2018[/TD]

[TD="class: xl72"]16[/TD]
[TD="class: xl68"]8335[/TD]
[TD="class: xl66"]Allen[/TD]
[TD="class: xl66"]CC From[/TD]
[TD="class: xl66"]GD6030300[/TD]
[TD="class: xl66"]5J880A[/TD]
[TD="class: xl66"]HG5500[/TD]
[TD="class: xl66"]00000000[/TD]
[TD="class: xl67, align: right"]2/15/2018[/TD]
[TD="class: xl67, align: right"]2/18/2018[/TD]

[TD="class: xl68"]17[/TD]
[TD="class: xl68"]8335[/TD]
[TD="class: xl66"]Allen[/TD]
[TD="class: xl66"]CC From[/TD]
[TD="class: xl66"]GD6030300[/TD]
[TD="class: xl66"]5J880A[/TD]
[TD="class: xl66"]HG5600[/TD]
[TD="class: xl66"]00000000[/TD]
[TD="class: xl67, align: right"]2/15/2018[/TD]
[TD="class: xl67, align: right"]2/18/2018[/TD]

[TD="class: xl68"]18[/TD]
[TD="class: xl71"]8335[/TD]
[TD="class: xl69"]Allen[/TD]
[TD="class: xl69"]CC To[/TD]
[TD="class: xl69"]450140300[/TD]
[TD="class: xl69"]5J880A[/TD]
[TD="class: xl69"]RTBL00[/TD]
[TD="class: xl69"]00000000[/TD]
[TD="class: xl70, align: right"]2/15/2018[/TD]
[TD="class: xl70, align: right"]2/18/2018[/TD]

</tbody>
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Solved
Looking For Tips To Improve My VBA
Replies
8
Views
198
who am i
W
O
  • Solved
VBA - floating photo
Replies
3
Views
341
RoryA
RoryA
M
  • Solved
Insert new row with incremental formula
Replies
8
Views
587
Sheik
S
K
  • Question Question
Help Needed
2
Replies
13
Views
319
kwavic
K
I
  • Solved
Insert new row happening on incorrect sheet
Replies
3
Views
152
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,911
Messages
6,175,326
Members
452,635
Latest member
laura12345

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