Summation Macro

B

boldcode

Active Member
Joined
Mar 12, 2010
Messages
347
<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> Hello,

I want to create a Macro that Inserts the Sum into COLUMN M in the ACTIVE WORKSHEET based on the following criteria (I know something similar can be down using a Pivot Table but I want to use a Macro):


In the worksheet I have data contained in COLUMNS A through O. In the example below I deleted the data in COLUMNS B – J, N, and O just to simplify things (the data in these columns does not matter for this Macro).


Data Before Macro:


<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> <table border="0" cellpadding="0" cellspacing="0" height="477" width="1025"><col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> <col style="mso-width-source:userset;mso-width-alt:1426;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:1389; width:29pt" span="2" width="38"> <col style="mso-width-source:userset;mso-width-alt:1426;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:1353; width:28pt" span="2" width="37"> <col style="mso-width-source:userset;mso-width-alt:1426; width:29pt" span="2" width="39"> <col style="mso-width-source:userset;mso-width-alt:1243;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:1280;width:26pt" width="35"> <col style="mso-width-source:userset;mso-width-alt:1389;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1572;width:32pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1682; width:35pt" span="2" width="46"> <tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:38pt" height="20" width="51">
</td> <td class="xl66" style="width:29pt" width="39">Col A</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col B</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col C</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col D</td> <td class="xl66" style="border-left:none;width:28pt" width="37">Col E</td> <td class="xl66" style="border-left:none;width:28pt" width="37">Col F</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col G</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col H</td> <td class="xl66" style="border-left:none;width:26pt" width="34">Col I</td> <td class="xl66" style="border-left:none;width:26pt" width="35">Col J</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col K</td> <td class="xl66" style="border-left:none;width:32pt" width="43">Col L</td> <td class="xl66" style="border-left:none;width:32pt" width="42">Col M</td> <td class="xl66" style="border-left:none;width:35pt" width="46">Col N</td> <td class="xl66" style="border-left:none;width:35pt" width="46">Col O</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">Row 1</td> <td class="xl67" style="border-left:none">EID</td> <td class="xl67" style="border-left:none">HT</td> <td class="xl67" style="border-left:none">BT</td> <td class="xl67" style="border-left:none">JT</td> <td class="xl67" style="border-left:none">AT</td> <td class="xl67" style="border-left:none">PT</td> <td class="xl67" style="border-left:none">BR</td> <td class="xl67" style="border-left:none">NT</td> <td class="xl67" style="border-left:none">MU</td> <td class="xl67" style="border-left:none">MK</td> <td class="xl67" style="border-left:none">PID</td> <td class="xl67" style="border-left:none">Hours</td> <td class="xl67" style="border-left:none">SPE</td> <td class="xl68" style="border-left:none">PTION</td> <td class="xl68" style="border-left:none">TOTAL</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 2</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">22</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-left:none"> </td> <td class="xl66" style="border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 3</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">319</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 4</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">289</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 5</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">69.5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 6</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">538.5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 7</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">86.5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 8</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">52.5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 9</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">1.5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 10</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 11</td> <td class="xl66" style="border-top:none;border-left:none">4</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 12</td> <td class="xl66" style="border-top:none;border-left:none">4</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> </tbody></table>

I want to sum the HOURS in COLUMN L based on EID (e.g. 3, 4 etc…) in COLUMN A and on the PID (e.g. 1 or 0) in COLUMN K. So if you look at the first EID VALUE in COLUMN A which is “3”, what the Macro would do is SUM the HOURS in COLUMN L for all the values that contain a “3” in COLUMN A and have a “1” in COLUMN K and INSERT the SUM INTO COLUMN M. Then it would SUM the HOURS in COLUMN L for all the values that contain a “3” in COLUMN A and have a “0” in COLUMN K and INSERT the SUM INTO COLUMN M. The Macro would do the same for value “4” in COLUMN A. Below is an example of what the data should look like after the Macro executes.

[FONT=&quot]Data After Macro:

[/FONT] <table border="0" cellpadding="0" cellspacing="0" height="471" width="1046"><col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> <col style="mso-width-source:userset;mso-width-alt:1426;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:1389; width:29pt" span="2" width="38"> <col style="mso-width-source:userset;mso-width-alt:1426;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:1353; width:28pt" span="2" width="37"> <col style="mso-width-source:userset;mso-width-alt:1426; width:29pt" span="2" width="39"> <col style="mso-width-source:userset;mso-width-alt:1243;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:1280;width:26pt" width="35"> <col style="mso-width-source:userset;mso-width-alt:1389;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1572;width:32pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1682; width:35pt" span="2" width="46"> <tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:38pt" height="20" width="51">
</td> <td class="xl66" style="width:29pt" width="39">Col A</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col B</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col C</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col D</td> <td class="xl66" style="border-left:none;width:28pt" width="37">Col E</td> <td class="xl66" style="border-left:none;width:28pt" width="37">Col F</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col G</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col H</td> <td class="xl66" style="border-left:none;width:26pt" width="34">Col I</td> <td class="xl66" style="border-left:none;width:26pt" width="35">Col J</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col K</td> <td class="xl66" style="border-left:none;width:32pt" width="43">Col L</td> <td class="xl66" style="border-left:none;width:32pt" width="42">Col M</td> <td class="xl66" style="border-left:none;width:35pt" width="46">Col N</td> <td class="xl66" style="border-left:none;width:35pt" width="46">Col O</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">Row 1</td> <td class="xl67" style="border-left:none">EID</td> <td class="xl67" style="border-left:none">HT</td> <td class="xl67" style="border-left:none">BT</td> <td class="xl67" style="border-left:none">JT</td> <td class="xl67" style="border-left:none">AT</td> <td class="xl67" style="border-left:none">PT</td> <td class="xl67" style="border-left:none">BR</td> <td class="xl67" style="border-left:none">NT</td> <td class="xl67" style="border-left:none">MU</td> <td class="xl67" style="border-left:none">MK</td> <td class="xl67" style="border-left:none">PID</td> <td class="xl67" style="border-left:none">Hours</td> <td class="xl67" style="border-left:none">SPE</td> <td class="xl68" style="border-left:none">PTION</td> <td class="xl68" style="border-left:none">TOTAL</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 2</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">22</td> <td class="xl66" style="border-top:none;border-left:none">313.5</td> <td class="xl66" style="border-left:none"> </td> <td class="xl66" style="border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 3</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">319</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 4</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">289</td> <td class="xl66" style="border-top:none;border-left:none">313.5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 5</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">69.5</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 6</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">538.5</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 7</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">86.5</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 8</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">52.5</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 9</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">1.5</td> <td class="xl66" style="border-top:none;border-left:none">313.5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 10</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">313.5</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 11</td> <td class="xl66" style="border-top:none;border-left:none">4</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">5</td> <td class="xl66" style="border-top:none;border-left:none">10</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 12</td> <td class="xl66" style="border-top:none;border-left:none">4</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">5</td> <td class="xl66" style="border-top:none;border-left:none">10</td> <td class="xl66" style="border-top:none;border-left:none"> </td> <td class="xl66" style="border-top:none;border-left:none"> </td> </tr> </tbody></table>
Thanks!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Try this:-
Code: 
[COLOR="Navy"]Sub[/COLOR] MG29Jun41
[COLOR="Navy"]Dim[/COLOR] Rng    [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn     [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Twn    [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Q
[COLOR="Navy"]Dim[/COLOR] K
[COLOR="Navy"]Set[/COLOR] Rng = Range(Range("A2"), Range("A" & rows.count).End(xlUp))
    [COLOR="Navy"]With[/COLOR] CreateObject("scripting.dictionary")
        .CompareMode = vbTextCompare
    [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
        Twn = Dn & Dn.Offset(, 10)
            [COLOR="Navy"]If[/COLOR] Not .Exists(Twn) [COLOR="Navy"]Then[/COLOR]
                .Add Twn, Array(Dn.Offset(, 12), Dn.Offset(, 11))
            [COLOR="Navy"]Else[/COLOR]
                Q = .Item(Twn)
                [COLOR="Navy"]Set[/COLOR] Q(0) = Union(Q(0), Dn.Offset(, 12))
                Q(1) = Q(1) + Val(Dn.Offset(, 11))
                .Item(Twn) = Q
            [COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR]
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] K [COLOR="Navy"]In[/COLOR] .keys
    .Item(K)(0).value = .Item(K)(1)
[COLOR="Navy"]Next[/COLOR] K
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
Hi MickG,

Your code that you provided me with is excellent and I was wondering how the code could be modified just a little bit. Below I re-explain the problem I had before and I highlighted in Red the change I would like to make. I also highlighted in Red the rows that contain "2" in PID.

Below is an explanation of what I am looking to do:

In the worksheet I have data contained in COLUMNS A through O. In the example below I deleted the data in COLUMNS B – J, N, and O just to simplify things (the data in these columns does not matter for this Macro).


Data Before Macro:


<table border="0" cellpadding="0" cellspacing="0" height="477" width="1025"><colgroup><col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> <col style="mso-width-source:userset;mso-width-alt:1426;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:1389; width:29pt" span="2" width="38"> <col style="mso-width-source:userset;mso-width-alt:1426;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:1353; width:28pt" span="2" width="37"> <col style="mso-width-source:userset;mso-width-alt:1426; width:29pt" span="2" width="39"> <col style="mso-width-source:userset;mso-width-alt:1243;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:1280;width:26pt" width="35"> <col style="mso-width-source:userset;mso-width-alt:1389;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1572;width:32pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1682; width:35pt" span="2" width="46"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:38pt" height="20" width="51">
</td> <td class="xl66" style="width:29pt" width="39">Col A</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col B</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col C</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col D</td> <td class="xl66" style="border-left:none;width:28pt" width="37">Col E</td> <td class="xl66" style="border-left:none;width:28pt" width="37">Col F</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col G</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col H</td> <td class="xl66" style="border-left:none;width:26pt" width="34">Col I</td> <td class="xl66" style="border-left:none;width:26pt" width="35">Col J</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col K</td> <td class="xl66" style="border-left:none;width:32pt" width="43">Col L</td> <td class="xl66" style="border-left:none;width:32pt" width="42">Col M</td> <td class="xl66" style="border-left:none;width:35pt" width="46">Col N</td> <td class="xl66" style="border-left:none;width:35pt" width="46">Col O</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">Row 1</td> <td class="xl67" style="border-left:none">EID</td> <td class="xl67" style="border-left:none">HT</td> <td class="xl67" style="border-left:none">BT</td> <td class="xl67" style="border-left:none">JT</td> <td class="xl67" style="border-left:none">AT</td> <td class="xl67" style="border-left:none">PT</td> <td class="xl67" style="border-left:none">BR</td> <td class="xl67" style="border-left:none">NT</td> <td class="xl67" style="border-left:none">MU</td> <td class="xl67" style="border-left:none">MK</td> <td class="xl67" style="border-left:none">PID</td> <td class="xl67" style="border-left:none">Hours</td> <td class="xl67" style="border-left:none">SPE</td> <td class="xl68" style="border-left:none">PTION</td> <td class="xl68" style="border-left:none">TOTAL</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 2</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">22</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-left:none">
</td> <td class="xl66" style="border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 3</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">2
</td> <td class="xl66" style="border-top:none;border-left:none">319</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 4</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">289</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 5</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">2
</td> <td class="xl66" style="border-top:none;border-left:none">69.5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 6</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">538.5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 7</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">86.5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 8</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">52.5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 9</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">1.5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 10</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 11</td> <td class="xl66" style="border-top:none;border-left:none">4</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 12</td> <td class="xl66" style="border-top:none;border-left:none">4</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> </tbody></table>

I want to sum the HOURS in COLUMN L based on EID (e.g. 3, 4 etc…) in COLUMN A and on the PID (e.g. 0,1 or 2) in COLUMN K. So if you look at the first EID VALUE in COLUMN A which is “3”, what the Macro would do is SUM the HOURS in COLUMN L for all the values that contain a “3” in COLUMN A and have a “1” or a "2" in COLUMN K and INSERT the SUM INTO COLUMN M (So essentially the 1's and 2's get add together for "EID 3"). Then it would SUM the HOURS in COLUMN L for all the values that contain a “3” in COLUMN A and have a “0” in COLUMN K and INSERT the SUM INTO COLUMN M. The Macro would do the same for value “4” in COLUMN A. Below is an example of what the data should look like after the Macro executes.

[FONT=&quot]Data After Macro:

[/FONT] <table border="0" cellpadding="0" cellspacing="0" height="471" width="1046"><colgroup><col style="mso-width-source:userset;mso-width-alt:1865;width:38pt" width="51"> <col style="mso-width-source:userset;mso-width-alt:1426;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:1389; width:29pt" span="2" width="38"> <col style="mso-width-source:userset;mso-width-alt:1426;width:29pt" width="39"> <col style="mso-width-source:userset;mso-width-alt:1353; width:28pt" span="2" width="37"> <col style="mso-width-source:userset;mso-width-alt:1426; width:29pt" span="2" width="39"> <col style="mso-width-source:userset;mso-width-alt:1243;width:26pt" width="34"> <col style="mso-width-source:userset;mso-width-alt:1280;width:26pt" width="35"> <col style="mso-width-source:userset;mso-width-alt:1389;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1572;width:32pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1682; width:35pt" span="2" width="46"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:38pt" height="20" width="51">
</td> <td class="xl66" style="width:29pt" width="39">Col A</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col B</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col C</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col D</td> <td class="xl66" style="border-left:none;width:28pt" width="37">Col E</td> <td class="xl66" style="border-left:none;width:28pt" width="37">Col F</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col G</td> <td class="xl66" style="border-left:none;width:29pt" width="39">Col H</td> <td class="xl66" style="border-left:none;width:26pt" width="34">Col I</td> <td class="xl66" style="border-left:none;width:26pt" width="35">Col J</td> <td class="xl66" style="border-left:none;width:29pt" width="38">Col K</td> <td class="xl66" style="border-left:none;width:32pt" width="43">Col L</td> <td class="xl66" style="border-left:none;width:32pt" width="42">Col M</td> <td class="xl66" style="border-left:none;width:35pt" width="46">Col N</td> <td class="xl66" style="border-left:none;width:35pt" width="46">Col O</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt" height="20">Row 1</td> <td class="xl67" style="border-left:none">EID</td> <td class="xl67" style="border-left:none">HT</td> <td class="xl67" style="border-left:none">BT</td> <td class="xl67" style="border-left:none">JT</td> <td class="xl67" style="border-left:none">AT</td> <td class="xl67" style="border-left:none">PT</td> <td class="xl67" style="border-left:none">BR</td> <td class="xl67" style="border-left:none">NT</td> <td class="xl67" style="border-left:none">MU</td> <td class="xl67" style="border-left:none">MK</td> <td class="xl67" style="border-left:none">PID</td> <td class="xl67" style="border-left:none">Hours</td> <td class="xl67" style="border-left:none">SPE</td> <td class="xl68" style="border-left:none">PTION</td> <td class="xl68" style="border-left:none">TOTAL</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 2</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">22</td> <td class="xl66" style="border-top:none;border-left:none">313.5</td> <td class="xl66" style="border-left:none">
</td> <td class="xl66" style="border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 3</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">2
</td> <td class="xl66" style="border-top:none;border-left:none">319</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 4</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">289</td> <td class="xl66" style="border-top:none;border-left:none">313.5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 5</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">2
</td> <td class="xl66" style="border-top:none;border-left:none">69.5</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 6</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">538.5</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 7</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">86.5</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 8</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">52.5</td> <td class="xl66" style="border-top:none;border-left:none">1066</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 9</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">1.5</td> <td class="xl66" style="border-top:none;border-left:none">313.5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 10</td> <td class="xl66" style="border-top:none;border-left:none">3</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">0</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">313.5</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 11</td> <td class="xl66" style="border-top:none;border-left:none">4</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">5</td> <td class="xl66" style="border-top:none;border-left:none">10</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl65" style="height:15.0pt;border-top:none" height="20">Row 12</td> <td class="xl66" style="border-top:none;border-left:none">4</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> <td class="xl66" style="border-top:none;border-left:none">1</td> <td class="xl66" style="border-top:none;border-left:none">5</td> <td class="xl66" style="border-top:none;border-left:none">10</td></tr></tbody></table>
 
Upvote 0
Try this:-
Code: 
[COLOR="Navy"]Sub[/COLOR] MG23Nov07
[COLOR="Navy"]Dim[/COLOR] Rng    [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn     [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Twn    [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Q
[COLOR="Navy"]Dim[/COLOR] K
[COLOR="Navy"]Dim[/COLOR] col [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
[COLOR="Navy"]Set[/COLOR] Rng = Range(Range("A2"), Range("A" & Rows.Count).End(xlUp))
    [COLOR="Navy"]With[/COLOR] CreateObject("scripting.dictionary")
        .CompareMode = vbTextCompare
    [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
        col = IIf(Dn.Offset(, 10) = 0, Dn.Offset(, 10), "A")
        Twn = Dn & col
            [COLOR="Navy"]If[/COLOR] Not .Exists(Twn) [COLOR="Navy"]Then[/COLOR]
                .Add Twn, Dn.Offset(, 11)
            [COLOR="Navy"]Else[/COLOR]
               [COLOR="Navy"]Set[/COLOR] .Item(Twn) = Union(.Item(Twn), Dn.Offset(, 11))
            [COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR]
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] K [COLOR="Navy"]In[/COLOR] .Keys
   .Item(K).Offset(, 1).Value = Application.Sum(.Item(K))
[COLOR="Navy"]Next[/COLOR] K
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]With[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
Mick,

I want to thank you for helping me twice already with your excellent code. I actually wanted to know if you could help me tweak your code to fit the description below:

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> I want to create a Macro that Inserts a SUM into COLUMN “ P ” CELLS in the ACTIVE WORKSHEET based on the requirements described below (I understand something similar can be done using a Pivot Table, but I want to use a Macro).


In the Active Worksheet, Row Titles exist in Column A Row 1 through Column Q Row 1. The rest of the cells in Columns A – Q contain data. In the example below I deleted the data in COLUMNS A – B, D – G, I – K, M – N, and Q just to simplify things (the data in these columns is not needed for the Macro). Below is an example of what the data looks like before the Macro is executed.

Data Before Macro:

<table style="width: 1930px; height: 337px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:2080;width:49pt" width="65"> <col style="mso-width-source:userset;mso-width-alt:1664; width:39pt" span="2" width="52"> <col style="mso-width-source:userset;mso-width-alt:1696; width:40pt" span="2" width="53"> <col style="mso-width-source:userset;mso-width-alt:2432;width:57pt" width="76"> <col style="mso-width-source:userset;mso-width-alt:1696;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:1728;width:41pt" width="54"> <col style="mso-width-source:userset;mso-width-alt:2816;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2624;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:1600;width:38pt" width="50"> <col style="mso-width-source:userset;mso-width-alt:2752;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:1600;width:38pt" width="50"> <col style="mso-width-source:userset;mso-width-alt:2592;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:2080;width:49pt" width="65"> <col style="mso-width-source:userset;mso-width-alt:2656;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:3008;width:71pt" width="94"> <col style="mso-width-source:userset;mso-width-alt:3296;width:77pt" width="103"> </colgroup><tbody><tr style="height:14.25pt" height="19"> <td class="xl66" style="height:14.25pt;width:49pt" height="19" width="65"> </td> <td class="xl68" style="width:39pt" width="52">Col A </td> <td class="xl68" style="border-left:none;width:39pt" width="52">Col B </td> <td class="xl68" style="border-left:none;width:40pt" width="53">Col C </td> <td class="xl68" style="border-left:none;width:40pt" width="53">Col D </td> <td class="xl68" style="border-left:none;width:57pt" width="76">Col E </td> <td class="xl68" style="border-left:none;width:40pt" width="53">Col F </td> <td class="xl68" style="border-left:none;width:41pt" width="54">Col G </td> <td class="xl68" style="border-left:none;width:66pt" width="88">Col H </td> <td class="xl68" style="border-left:none;width:62pt" width="82">Col I </td> <td class="xl68" style="border-left:none;width:38pt" width="50">Col J </td> <td class="xl68" style="border-left:none;width:65pt" width="86">Col K </td> <td class="xl68" style="border-left:none;width:38pt" width="50">Col L </td> <td class="xl68" style="border-left:none;width:61pt" width="81">Col M </td> <td class="xl68" style="border-left:none;width:49pt" width="65">Col N </td> <td class="xl68" style="border-left:none;width:62pt" width="83">Col O</td> <td class="xl68" style="border-left:none;width:71pt" width="94">Col P</td> <td class="xl68" style="border-left:none;width:77pt" width="103">Col Q</td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt" height="19">Row 1 </td> <td class="xl67" style="border-top:none;border-left:none">B ID</td> <td class="xl67" style="border-top:none;border-left:none">Name</td> <td class="xl77" style="border-top:none;border-left:none">Org</td> <td class="xl67" style="border-top:none;border-left:none">Div</td> <td class="xl67" style="border-top:none;border-left:none">T Number</td> <td class="xl67" style="border-top:none;border-left:none">Model</td> <td class="xl67" style="border-top:none;border-left:none">Make</td> <td class="xl77" style="border-top:none;border-left:none">S Function</td> <td class="xl67" style="border-top:none;border-left:none">E Function</td> <td class="xl67" style="border-top:none;border-left:none">Type</td> <td class="xl67" style="border-top:none;border-left:none">Description</td> <td class="xl77" style="border-top:none;border-left:none">P ID</td> <td class="xl67" style="border-top:none;border-left:none">OG Hours </td> <td class="xl67" style="border-top:none;border-left:none">Sum EA</td> <td class="xl77" style="border-top:none;border-left:none">P Hours</td> <td class="xl77" style="border-top:none;border-left:none">Sum P</td> <td class="xl67" style="border-top:none;border-left:none">S Hours</td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 2 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Cont</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">2</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">28</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 3 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Cont</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">404</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 4</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Eng</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">88</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 5 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Cont</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">681</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 6 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Cont</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">109</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 7 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">PM</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">66</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 8 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">PM</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">2</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">2</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 9 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">PM</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">2</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">1</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 10 </td> <td class="xl71" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">Bore</td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">Eng</td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">1</td> <td class="xl73" style="border-top:none;border-left:none"> </td> <td class="xl73" style="border-top:none;border-left:none"> </td> <td class="xl73" style="border-top:none;border-left:none">48</td> <td class="xl71" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 11</td> <td class="xl71" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">Bore</td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">Eng</td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">2</td> <td class="xl73" style="border-top:none;border-left:none"> </td> <td class="xl73" style="border-top:none;border-left:none"> </td> <td class="xl73" style="border-top:none;border-left:none">6</td> <td class="xl71" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 12</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Yorn</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Plan</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">1</td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none">817</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 13</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Yorn</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">PM</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">1</td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none">91</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 14</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Yorn</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">PM</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">1</td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none">475</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 15</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Yorn</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">PM</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">2</td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none">7</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> </tr> </tbody></table>

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w:DontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> I want use the hours in Column “O” to produce SUMs that will go into COLUMN “P” CELLS based on the data in these three Columns:


1. Org (e.g. Times, Bore, etc…) in Column C
2. S Function (e.g. Cont Admin, Cont, Eng, etc…) in Column H
3. P ID (e.g. 1 or 2) in Column L


Let’s use Rows 2 – 9 as an example to describe how the Macro should function. Cell “C2” contains the word “Times”, cell “H2” contains the word “Cont”, cell “L2” contains the number “2” and lastly cell “O2” contains the number of hours (in this case the number is “28”). I want the Macro to ADD all hours for those rows whose contents match up under Columns C, H, and L. The sum of these hours will be placed in Column P cells. So in our example if only ONE row exists with the contents: Times, Cont, and 2 under Columns C, H, and L…then the number of hours in cell “O2” which is 28 in this case would be placed into cell “P2”. If TWO rows existed with the contents: Times, Cont, and 2 under Columns C, H, and L…then the sum of these hours from Column O cells would be inputted into Column P cells.



Below is an example of what the data should look like after the Macro executes. I added several rows with different data to provide a better demonstration of what the Macro should do.

[FONT=&quot]Data After Macro:[/FONT]

<table style="width: 2417px; height: 338px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:2080;width:49pt" width="65"> <col style="mso-width-source:userset;mso-width-alt:1664; width:39pt" span="2" width="52"> <col style="mso-width-source:userset;mso-width-alt:1696; width:40pt" span="2" width="53"> <col style="mso-width-source:userset;mso-width-alt:2432;width:57pt" width="76"> <col style="mso-width-source:userset;mso-width-alt:1696;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:1728;width:41pt" width="54"> <col style="mso-width-source:userset;mso-width-alt:2816;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:2624;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:1600;width:38pt" width="50"> <col style="mso-width-source:userset;mso-width-alt:2752;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:1600;width:38pt" width="50"> <col style="mso-width-source:userset;mso-width-alt:2592;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:2080;width:49pt" width="65"> <col style="mso-width-source:userset;mso-width-alt:2656;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:3008;width:71pt" width="94"> <col style="mso-width-source:userset;mso-width-alt:3296;width:77pt" width="103"> </colgroup><tbody><tr style="height:14.25pt" height="19"> <td class="xl66" style="height:14.25pt;width:49pt" height="19" width="65"> </td> <td class="xl68" style="width:39pt" width="52">Col A </td> <td class="xl68" style="border-left:none;width:39pt" width="52">Col B </td> <td class="xl68" style="border-left:none;width:40pt" width="53">Col C </td> <td class="xl68" style="border-left:none;width:40pt" width="53">Col D </td> <td class="xl68" style="border-left:none;width:57pt" width="76">Col E </td> <td class="xl68" style="border-left:none;width:40pt" width="53">Col F </td> <td class="xl68" style="border-left:none;width:41pt" width="54">Col G </td> <td class="xl68" style="border-left:none;width:66pt" width="88">Col H </td> <td class="xl68" style="border-left:none;width:62pt" width="82">Col I </td> <td class="xl68" style="border-left:none;width:38pt" width="50">Col J </td> <td class="xl68" style="border-left:none;width:65pt" width="86">Col K </td> <td class="xl68" style="border-left:none;width:38pt" width="50">Col L </td> <td class="xl68" style="border-left:none;width:61pt" width="81">Col M </td> <td class="xl68" style="border-left:none;width:49pt" width="65">Col N </td> <td class="xl68" style="border-left:none;width:62pt" width="83">Col O</td> <td class="xl68" style="border-left:none;width:71pt" width="94">Col P</td> <td class="xl68" style="border-left:none;width:77pt" width="103">Col Q</td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt" height="19">Row 1 </td> <td class="xl67" style="border-top:none;border-left:none">B ID</td> <td class="xl67" style="border-top:none;border-left:none">Name</td> <td class="xl77" style="border-top:none;border-left:none">Org</td> <td class="xl67" style="border-top:none;border-left:none">Div</td> <td class="xl67" style="border-top:none;border-left:none">T Number</td> <td class="xl67" style="border-top:none;border-left:none">Model</td> <td class="xl67" style="border-top:none;border-left:none">Make</td> <td class="xl77" style="border-top:none;border-left:none">S Function</td> <td class="xl67" style="border-top:none;border-left:none">E Function</td> <td class="xl67" style="border-top:none;border-left:none">Type</td> <td class="xl67" style="border-top:none;border-left:none">Description</td> <td class="xl77" style="border-top:none;border-left:none">P ID</td> <td class="xl67" style="border-top:none;border-left:none">OG Hours </td> <td class="xl67" style="border-top:none;border-left:none">Sum EA</td> <td class="xl77" style="border-top:none;border-left:none">P Hours</td> <td class="xl77" style="border-top:none;border-left:none">Sum P</td> <td class="xl67" style="border-top:none;border-left:none">S Hours</td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 2 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Cont</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">2</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">28</td> <td class="xl69" style="border-top:none;border-left:none">28</td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 3 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Cont</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">404</td> <td class="xl69" style="border-top:none;border-left:none">1194</td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 4</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Eng</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">88</td> <td class="xl69" style="border-top:none;border-left:none">88</td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 5 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Cont</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">681</td> <td class="xl69" style="border-top:none;border-left:none">1194</td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 6 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Cont</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">109</td> <td class="xl69" style="border-top:none;border-left:none">1194</td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 7 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">PM</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">66</td> <td class="xl69" style="border-top:none;border-left:none">66</td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 8 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">PM</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">2</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">2</td> <td class="xl69" style="border-top:none;border-left:none">3</td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 9 </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">Times</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">PM</td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none"> </td> <td class="xl69" style="border-top:none;border-left:none">2</td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none"> </td> <td class="xl70" style="border-top:none;border-left:none">1</td> <td class="xl69" style="border-top:none;border-left:none">3</td> <td class="xl69" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 10 </td> <td class="xl71" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">Bore</td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">Eng</td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">1</td> <td class="xl73" style="border-top:none;border-left:none"> </td> <td class="xl73" style="border-top:none;border-left:none"> </td> <td class="xl73" style="border-top:none;border-left:none">48</td> <td class="xl71" style="border-top:none;border-left:none">48</td> <td class="xl72" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 11</td> <td class="xl71" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">Bore</td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">Eng</td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl72" style="border-top:none;border-left:none"> </td> <td class="xl71" style="border-top:none;border-left:none">2</td> <td class="xl73" style="border-top:none;border-left:none"> </td> <td class="xl73" style="border-top:none;border-left:none"> </td> <td class="xl73" style="border-top:none;border-left:none">6</td> <td class="xl71" style="border-top:none;border-left:none">6</td> <td class="xl72" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 12</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Yorn</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Plan</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">1</td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none">817</td> <td class="xl74" style="border-top:none;border-left:none">817</td> <td class="xl75" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 13</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Yorn</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">PM</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">1</td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none">91</td> <td class="xl74" style="border-top:none;border-left:none">566</td> <td class="xl75" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 14</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Yorn</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">PM</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">1</td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none">475</td> <td class="xl74" style="border-top:none;border-left:none">566</td> <td class="xl75" style="border-top:none;border-left:none"> </td> </tr> <tr style="height:14.25pt" height="19"> <td class="xl68" style="height:14.25pt;border-top:none" height="19">Row 15</td> <td class="xl74" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">Yorn</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">PM</td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl75" style="border-top:none;border-left:none"> </td> <td class="xl74" style="border-top:none;border-left:none">2</td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none"> </td> <td class="xl76" style="border-top:none;border-left:none">7</td> <td class="xl74" style="border-top:none;border-left:none">7</td> <td class="xl75" style="border-top:none;border-left:none"> </td> </tr> </tbody></table>

Thank you,

BC
 
Upvote 0
Try this:-
Code: 
[COLOR="Navy"]Sub[/COLOR] MG02Dec04
[COLOR="Navy"]Dim[/COLOR] Rng     [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn      [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Tri     [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
[COLOR="Navy"]Set[/COLOR] Rng = Range(Range("C2"), Range("C" & Rows.Count).End(xlUp))
[COLOR="Navy"]With[/COLOR] CreateObject("scripting.dictionary")
.CompareMode = vbTextCompare
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
    Tri = Dn & Dn.Offset(, 5) & Dn.Offset(, 9)
        [COLOR="Navy"]If[/COLOR] Not .Exists(Tri) [COLOR="Navy"]Then[/COLOR]
            .Add Tri, Dn
            Dn.Offset(, 13) = Dn.Offset(, 12)
        [COLOR="Navy"]Else[/COLOR]
            [COLOR="Navy"]Set[/COLOR] .Item(Tri) = Union(.Item(Tri), Dn)
            .Item(Tri).Offset(, 13) = Application.Sum(.Item(Tri).Offset(, 12))
        [COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]With[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
617
smozgur
smozgur
A
  • Question Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
2K
Attrazion
A
E
  • Question Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
518
esben
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
M
  • Question Question
Help with FilterXML formula
Replies
0
Views
2K
montex01
M

Forum statistics

Threads
1,224,525
Messages
6,179,319
Members
452,905
Latest member
deadwings

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top