Macro + SUBTOTAL + InsRow + Page Break help!

xbrianx · Sep 14, 2011

If you can figure this out, you are the Master Excel Sensei of all senseis!

I have 3 columns of data. I have 60 schools (school name are the only values in column 'A'). Each school has multiple different sections (classifications) of employees along with their percentage. See example below where I have Asheville School - note that there are 4 different sections (classifications) of employees:

 <table class="MsoNormalTable" style="margin-left: 4.65pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" height="425" width="461"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:12.75pt"> <td style="width:66.95pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT]
</td> <td style="width:212.8pt;border:solid black 1.0pt; mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="284">
</td> <td style="width:31.5pt;border:solid black 1.0pt;border-left: none;mso-border-top-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="42">
</td> </tr> <tr style="mso-yfti-irow:1;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;mso-border-alt: solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Director of High School Education[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:2;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Director Elementary Education[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:3;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Associate Superintendent[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:4;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284">
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42">
</td> </tr> <tr style="mso-yfti-irow:5;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]PE Teacher[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:6;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Curriculum Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:7;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Cultural Arts[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:8;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]K-12 Science Curriculum Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:9;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]K-12 Science Curriculum Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:10;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]K-12 Mathematics Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:11;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284">
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42">
</td> </tr> <tr style="mso-yfti-irow:12;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Distance Learning Teacher[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:13;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Technology Facilitator (RttT)[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:14;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Technology Facilitator (RttT)[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:15;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284">
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42">
</td> </tr> <tr style="mso-yfti-irow:16;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]High School Literacy Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:17;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]High School Literacy Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:18;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:19;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:20;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Curriculum Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:21;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Instructional Services Mentor[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]40[/FONT]
</td> </tr> <tr style="mso-yfti-irow:22;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:23;mso-yfti-lastrow:yes;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89">
</td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> </tbody></table>
I need help with several macros and formulas:
1) Each section of employees within the school needs the SUBTOTAL formula added and then divided by 100 (to get an employee count). So in cell C5 I need "=(SUBTOTAL(9,C2:C4))/100" inserted.
2) I would like cell C5 BOLD with BLACK fill and WHITE font color value to two (2) decimal places.
3) I would like the word, "SUBTOTAL" written in BOLD in cell B5 (to the left of the formula).
4) I need the SUBTOTAL command and "SUBTOTAL" word repeated for each section - the sections are divided by a blank row.
5) In cell C29, I again would use the =(SUBTOTAL(9,C1:C28))/100 formula to sum up all the subtotals for the school to get me a total employee count.
6) I would like cell C29 BOLD with RED fill and WHITE font color and the value to two (2) decimal places.
would like the
7) I would like the words, "TOTAL FOR SCHOOL" written in BOLD in cell B28 (to the left of the formula).
8) Insert a page break between schools (where there is a new, unique value in Column 'A') and then repeat for the remaining 59 schools.

 <table class="MsoNormalTable" style="width:246.65pt;margin-left:4.65pt;border-collapse:collapse;mso-yfti-tbllook: 1184;mso-padding-alt:0in 5.4pt 0in 5.4pt" border="0" cellpadding="0" cellspacing="0" width="329"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:12.75pt"> <td style="width:57.65pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="77"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT]
</td> <td style="width:163.0pt;border:solid black 1.0pt; mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="217">
</td> <td style="width:26.0pt;border:solid black 1.0pt;border-left: none;mso-border-top-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="35">
</td> </tr> <tr style="mso-yfti-irow:1;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;mso-border-alt: solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Director of High School Education[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:2;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Director Elementary Education[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:3;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Associate Superintendent[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:4;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]SUBTOTAL[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;background:black; padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]3.00[/FONT]
</td> </tr> <tr style="mso-yfti-irow:5;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217">
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35">
</td> </tr> <tr style="mso-yfti-irow:6;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]PE Teacher[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:7;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Curriculum Specialist[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:8;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Cultural Arts[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:9;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]K-12 Science Curriculum Specialist[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:10;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]K-12 Science Curriculum Specialist[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:11;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]K-12 Mathematics Specialist[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:12;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]SUBTOTAL[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;background:black; padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]5.00[/FONT]
</td> </tr> <tr style="mso-yfti-irow:13;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217">
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35">
</td> </tr> <tr style="mso-yfti-irow:14;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Distance Learning Teacher[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:15;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Technology Facilitator (RttT)[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:16;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Technology Facilitator (RttT)[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:17;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]SUBTOTAL[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;background:black; padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]1.50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:18;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217">
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35">
</td> </tr> <tr style="mso-yfti-irow:19;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]High School Literacy Coach[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:20;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]High School Literacy Coach[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:21;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:22;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:23;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Curriculum Specialist[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:24;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Instructional Services Mentor[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]40[/FONT]
</td> </tr> <tr style="mso-yfti-irow:25;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:26;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:27;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]SUBTOTAL[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;background:black; padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]4.40[/FONT]
</td> </tr> <tr style="mso-yfti-irow:28;mso-yfti-lastrow:yes;height:12.75pt"> <td style="width:57.65pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="77">
</td> <td style="width:163.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="217"> [FONT=&quot]TOTAL FOR SCHOOL[/FONT]
</td> <td style="width:26.0pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;background:red; padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="35"> [FONT=&quot]13.9[/FONT]
</td> </tr> </tbody></table>
I know, I know... I am getting very specific here but I know there is someone out there that knows what to do, or who can at least get me very close. Thanks in advance!

venkat1926 · Sep 15, 2011

is there any logic for the computer (which is nothing but a high speed idiot) to distinguish among each section. other wise you have to enter a columns D and enter the section number in each school which is going to be cumbersome. If you have a logic it would be easier.

xbrianx · Sep 15, 2011

venkat1926 said:
is there any logic for the computer (which is nothing but a high speed idiot) to distinguish among each section?

Yes, there is. Column 'A' - School Name - is the only value listed in that column 'A'. So the logic would be WHERE column 'A' = (Value) THEN NEXT section starts. The main thing I I wanting is the AUTO SUBTOTAL entered at the end of each section. VoG, any ideas?

venkat1926 · Sep 16, 2011

no.school name occurs first row. but your first section contains only 2,3 and 4th rows.
second section contains from pE teacher to K12 mathematics specialist etc that I doubt whether the computer can recognise. I suggest introduce another columns
agast director of hight school ed type 1 and also two more rows down
Pe techher to K12 will have numbers 2 etc. then you can use subtotal function for each section under each school . I hope I make myself clear.

xbrianx · Sep 16, 2011

What about if I copied the school name in column 'A' down to the next school, would that help in creating a macro to add the =SUBTOTAL formula?

<table class="MsoNormalTable" border="0" cellpadding="0" cellspacing="0" height="425" width="461"><tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:12.75pt"><td style="width:66.95pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" valign="bottom" width="89">[FONT=&quot]ASHEVILLE SCHOOL[/FONT]
</td> <td style="width:212.8pt;border:solid black 1.0pt; mso-border-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="284">
</td> <td style="width:31.5pt;border:solid black 1.0pt;border-left: none;mso-border-top-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="42">
</td> </tr> <tr style="mso-yfti-irow:1;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;mso-border-alt: solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height:12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Director of High School Education[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:2;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Director Elementary Education[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:3;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Associate Superintendent[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:4;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284">
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42">
</td> </tr> <tr style="mso-yfti-irow:5;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]PE Teacher[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:6;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Curriculum Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:7;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Cultural Arts[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:8;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]K-12 Science Curriculum Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:9;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]K-12 Science Curriculum Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:10;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]K-12 Mathematics Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]100[/FONT]
</td> </tr> <tr style="mso-yfti-irow:11;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284">
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42">
</td> </tr> <tr style="mso-yfti-irow:12;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Distance Learning Teacher[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:13;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Technology Facilitator (RttT)[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:14;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Technology Facilitator (RttT)[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:15;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284">
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42">
</td> </tr> <tr style="mso-yfti-irow:16;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]High School Literacy Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:17;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]High School Literacy Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:18;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:19;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:20;height:12.75pt"> <td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td> <td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Curriculum Specialist[/FONT]
</td> <td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td> </tr> <tr style="mso-yfti-irow:21;height:12.75pt"><td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td><td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Instructional Services Mentor[/FONT]
</td><td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]40[/FONT]
</td></tr><tr style="mso-yfti-irow:22;height:12.75pt"><td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td><td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td><td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]50[/FONT]
</td></tr><tr style="mso-yfti-irow:23;mso-yfti-lastrow:yes;height:12.75pt"><td style="width:66.95pt;border:solid black 1.0pt;border-top: none;mso-border-left-alt:solid black .5pt;mso-border-bottom-alt:solid black .5pt; mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt;height: 12.75pt" nowrap="nowrap" width="89"> [FONT=&quot]ASHEVILLE SCHOOL[/FONT] </td><td style="width:212.8pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="284"> [FONT=&quot]Elementary Instructional Coach[/FONT]
</td><td style="width:31.5pt;border-top:none;border-left:none; border-bottom:solid black 1.0pt;border-right:solid black 1.0pt;mso-border-bottom-alt: solid black .5pt;mso-border-right-alt:solid black .5pt;padding:0in 5.4pt 0in 5.4pt; height:12.75pt" nowrap="nowrap" width="42"> [FONT=&quot]10[/FONT]</td></tr> </tbody></table>

venkat1926 · Sep 16, 2011

that wont help. that will give you subtotal for the school as a whole. :But you need within each school subtotal for each section. But deliberately or ;by change you have given both B and C column blank after each section. If this is the type of data base the solution can be found in the macro test" given below.

I am giving the data base as visualised by me below. note after each section the columns B and c are blank. sheet 1 is copied in shseet 2 also. the subtotals for each section are in the column D in sheet 1.the database given below is after running macro "test".

If you want to retest.
run "undo" first and then run test

Excel Workbook

A

B

C

D

1

ASHEVILLE SCHOOL

Director of High School Education

100

2

ASHEVILLE SCHOOL

Director Elementary Education

100

3

ASHEVILLE SCHOOL

Associate Superintendent

100

300

4

ASHEVILLE SCHOOL

5

ASHEVILLE SCHOOL

PE Teacher

100

6

ASHEVILLE SCHOOL

Curriculum Specialist

100

7

ASHEVILLE SCHOOL

Cultural Arts

100

8

ASHEVILLE SCHOOL

K-12 Science Curriculum Specialist

50

9

ASHEVILLE SCHOOL

K-12 Science Curriculum Specialist

50

10

ASHEVILLE SCHOOL

K-12 Mathematics Specialist

100

500

11

ASHEVILLE SCHOOL

12

ASHEVILLE SCHOOL

Distance Learning Teacher

50

13

ASHEVILLE SCHOOL

Technology Facilitator (RttT)

50

14

ASHEVILLE SCHOOL

Technology Facilitator (RttT)

50

150

15

ASHEVILLE SCHOOL

16

ASHEVILLE SCHOOL

High School Literacy Coach

50

17

ASHEVILLE SCHOOL

High School Literacy Coach

50

18

ASHEVILLE SCHOOL

Elementary Instructional Coach

50

19

ASHEVILLE SCHOOL

Elementary Instructional Coach

50

20

ASHEVILLE SCHOOL

Curriculum Specialist

50

250

Sheet1

Code:

Sub test()
Dim r As Range, c As Range
Set r = Range(Range("C1"), Cells(Rows.Count, "C").End(xlUp).Offset(1, 0))
For Each c In r
If c = "" Then c.Offset(-1, 1) = WorksheetFunction.Sum(Range(c.Offset(-1, 0), c.Offset(-1, 0).End(xlUp)))
Next c


End Sub

Code:

Sub undo()
Worksheets("sheet1").Cells.Clear
Worksheets("sheet2").Cells.Copy Worksheets("sheet1").Range("A1")
End Sub

Macro + SUBTOTAL + InsRow + Page Break help!

xbrianx

New Member

Excel Facts

venkat1926

Well-known Member

xbrianx

New Member

venkat1926

Well-known Member

xbrianx

New Member

venkat1926

Well-known Member

Similar threads

Forum statistics

Share this page

Macro + SUBTOTAL + InsRow + Page Break help!

xbrianx

New Member

Excel Facts

venkat1926

Well-known Member

xbrianx

New Member

venkat1926

Well-known Member

xbrianx

New Member

venkat1926

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock