I have a report that is generated automatically in the following format:
<tbody>
</tbody>
This goes on for around 10,000 rows. Where it says REP12 is where the report page break is and REP12 is the report number. Random placement.
I want to quickly add the class to column A of the table for each group. For example, the first group would read:
<tbody>
</tbody>
As you can see, the way the report is originally formatted, there are spaces and sometimes other information in between the classes and item numbers.
Any thoughts as to which technique to write this VBA?
1 | APPLE 1 | |
2 | APPLE 2 | |
3 | APPLE 3 | |
CLASS A | FRUIT | |
5 | BLUE 5 | |
6 | BLUE 6 | |
7 | BLUE 7 | |
8 | BLUE 8 | |
REP12 | ||
CLASS B | COLOR | |
11 | CIRCLE 11 | |
12 | CIRCLE 12 | |
CLASS C | SHAPE |
<tbody>
</tbody>
This goes on for around 10,000 rows. Where it says REP12 is where the report page break is and REP12 is the report number. Random placement.
I want to quickly add the class to column A of the table for each group. For example, the first group would read:
CLASS A | 1 | APPLE 1 |
CLASS A | 2 | APPLE 2 |
CLASS A | 3 | APPLE 3 |
<tbody>
</tbody>
As you can see, the way the report is originally formatted, there are spaces and sometimes other information in between the classes and item numbers.
Any thoughts as to which technique to write this VBA?