Need to add rows based on previous column values

[csimpson24]

Hello all,

Ripping my hair out over this one and cannot find an answer anywhere. Here is an example of my data. I want to automatically add a new row after the last job entry. So in the example below, I would add a new row for job 106144 with Opr 60, a new row for job 108422 with Opr 30, a new row for Job 108466 with Opr 20, and so on. Any help would be GREATLY appreciated. It's been years since I've written in VBA by the way.

[TABLE="width: 527"]
<tbody>[TR]
[TD][TABLE="width: 527"]
<tbody>[TR]
[TD]JobNum[/TD]
[TD]Company[/TD]
[TD]Plant[/TD]
[TD]Asm[/TD]
[TD]Opr[/TD]
[TD]Operation[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 527"]
<colgroup><col><col span="2"><col span="2"><col></colgroup><tbody>[TR]
[TD]106144[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]MECHENG[/TD]
[/TR]
[TR]
[TD]106144[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]MACH[/TD]
[/TR]
[TR]
[TD]106144[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]30[/TD]
[TD]FAB[/TD]
[/TR]
[TR]
[TD]106144[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]40[/TD]
[TD]ASSEM[/TD]
[/TR]
[TR]
[TD]106144[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]50[/TD]
[TD]TEST[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 527"]
<colgroup><col><col span="2"><col span="2"><col></colgroup><tbody>[TR]
[TD]108422[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]FAB[/TD]
[/TR]
[TR]
[TD]108422[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]MACH[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 527"]
<colgroup><col><col span="2"><col span="2"><col></colgroup><tbody>[TR]
[TD]108446[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]MACH[/TD]
[/TR]
[TR]
[TD]108449[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]FAB[/TD]
[/TR]
[TR]
[TD]108449[/TD]
[TD]GCB[/TD]
[TD]GCB[/TD]
[TD]0[/TD]
[TD]20[/TD]
[TD]MACH[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Glad to help & thanks for the feedback