Hi and thank you for looking,
I'm trying to create a macro to insert page breaks above each Header row (Row 1,7,11 in this ex) and if the data between each header contains more than 3 rows, insert a page break every 3 rows. So, below the macro would place a page break between row 4&5, 6&7, 10&11.
This data is Dynamic and the amount of rows between each header varies from file to file.
I've tried to record the macro and create code with no luck. I know there will most likely be a loop and rely on the
<tbody>
</tbody>
I'm trying to create a macro to insert page breaks above each Header row (Row 1,7,11 in this ex) and if the data between each header contains more than 3 rows, insert a page break every 3 rows. So, below the macro would place a page break between row 4&5, 6&7, 10&11.
This data is Dynamic and the amount of rows between each header varies from file to file.
I've tried to record the macro and create code with no luck. I know there will most likely be a loop and rely on the
A | B | C | D | E | F | G | H | I | J | |
1 | Header Text | x | ||||||||
2 | x | x | x | x | x | x | x | x | x | x |
3 | x | x | x | x | x | x | x | x | x | x |
4 | x | x | x | x | x | x | x | x | x | x |
5 | x | x | x | x | x | x | x | x | x | x |
6 | x | x | x | x | x | x | x | x | x | x |
7 | Header Text | x | ||||||||
8 | x | x | x | x | x | x | x | x | x | x |
9 | x | x | x | x | x | x | x | x | x | x |
10 | x | x | x | x | x | x | x | x | x | x |
11 | Header Text |
<tbody>
</tbody>