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.

JobNum Company Plant Asm Opr Operation <tbody> </tbody> 106144 GCB GCB 0 10 MECHENG 106144 GCB GCB 0 20 MACH 106144 GCB GCB 0 30 FAB 106144 GCB GCB 0 40 ASSEM 106144 GCB GCB 0 50 TEST <colgroup><col><col span="2"><col span="2"><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

108422	GCB	GCB	0	10	FAB
108422	GCB	GCB	0	20	MACH

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

108446	GCB	GCB	0	10	MACH
108449	GCB	GCB	0	10	FAB
108449	GCB	GCB	0	20	MACH

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

 

[Fluff]

Glad to help & thanks for the feedback