I am looking for a Formulas or VBA to copy this to sheet 2. If I have this.
<colgroup><col><col></colgroup><tbody>
</tbody>
But this is what I need I need the Subtotal to be removed so it will look like this.
<colgroup><col><col></colgroup><tbody>
</tbody>
Please can someone help thanks
Assigned Role | Assigned |
1-2-8-26-1-1-11 | ARTHUR |
1-2-8-26-1-1-11 | CHARLOTTE |
Subtotal | |
1-2-8-26-1-2-13 | MARSHALL |
1-2-8-26-1-2-13 | MATTHEW |
1-2-8-26-1-2-13 | PASCAL |
Subtotal | |
1-2-8-26-1-1-12 | ABRIL |
1-2-8-26-1-1-12 | BRIA |
1-2-8-26-1-1-12 | DIANNA |
Subtotal | |
1-2-8-26-2-2-12 | JERMELL |
Subtotal |
<colgroup><col><col></colgroup><tbody>
</tbody>
But this is what I need I need the Subtotal to be removed so it will look like this.
Assigned Role | Assigned |
1-2-8-26-1-1-11 | ARTHUR |
1-2-8-26-1-1-11 | CHARLOTTE |
1-2-8-26-1-2-13 | MARSHALL |
1-2-8-26-1-2-13 | MATTHEW |
1-2-8-26-1-2-13 | PASCAL |
1-2-8-26-1-1-12 | ABRIL |
1-2-8-26-1-1-12 | BRIA |
1-2-8-26-1-1-12 | DIANNA |
1-2-8-26-2-2-12 | JERMELL |
<colgroup><col><col></colgroup><tbody>
</tbody>
Please can someone help thanks