Hi all
(picture attached to explain this).
I have an excel form that we're using for training and compliance inspections. It has 5 sections, each with a unique category. The main section is for my "Observations", and I used VBA and a button to add rows beneath it for "action items" - things I need the people on that site to do. Each of my 5 main sections can have action items added to it, so action items could appear in 5 different places.
This means that Category A gets longer each time an action item is added, and so does Category B, C, D, and E. Some days CAtegory A could be 10 rows. and the other ones are 3 rows, or 7. What ends up happening is the page break appears somewhere in the middle of one of the categories dividing the action items from their header category, or even in between 2 linked action items.
Is there any way to use VBA so it automatically places the page break line in between 2 sections/categories (below that categories action items but above the next category header).
(picture attached to explain this).
I have an excel form that we're using for training and compliance inspections. It has 5 sections, each with a unique category. The main section is for my "Observations", and I used VBA and a button to add rows beneath it for "action items" - things I need the people on that site to do. Each of my 5 main sections can have action items added to it, so action items could appear in 5 different places.
This means that Category A gets longer each time an action item is added, and so does Category B, C, D, and E. Some days CAtegory A could be 10 rows. and the other ones are 3 rows, or 7. What ends up happening is the page break appears somewhere in the middle of one of the categories dividing the action items from their header category, or even in between 2 linked action items.
Is there any way to use VBA so it automatically places the page break line in between 2 sections/categories (below that categories action items but above the next category header).
