Excel SumIF Formula or Macro Needed?

[Bigfille26]

(I’ve included a picture of my spreadsheet data below) I’m not sure how to go about summing certain row’s “Amount in Local Currency” based on the “G/L Account”. What I need to do is for all the rows with “G/L Accounts” that start with the same first three numbers, such as 627, sum the respective “Amount in Local Currency” and insert the total. Then move on down the worksheet to the next “G/L Account”. I have to do this on numerous worksheets with each worksheet having a unique amount of rows but still the same “G/L Account” Numbers. I’m unsure as to whether a Macro or something like a SumIF function is whats needed for this. Any help will be greatly appreciated.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>



<TABLE style="WIDTH: 1007pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1341><COLGROUP><COL style="WIDTH: 100pt; mso-width-source: userset; mso-width-alt: 4864" width=133><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 3840" width=105><COL style="WIDTH: 122pt; mso-width-source: userset; mso-width-alt: 5924" width=162><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 3913" width=107><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 158pt; mso-width-source: userset; mso-width-alt: 7716" width=211><COL style="WIDTH: 289pt; mso-width-source: userset; mso-width-alt: 14080" width=385><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #dddddd; WIDTH: 100pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=20 width=133>Reference</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dddddd; WIDTH: 62pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=82>Posting Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dddddd; WIDTH: 79pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 width=105>Document Date</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dddddd; WIDTH: 122pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=162> Amount in local currency </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dddddd; WIDTH: 57pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=76>Cost Center</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dddddd; WIDTH: 80pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 width=107> Purchase Order </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dddddd; WIDTH: 60pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=80>G/L Account</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dddddd; WIDTH: 158pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=211>G/L Description</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #dddddd; WIDTH: 289pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=385>Text</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/6/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>11/4/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$40.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500025195</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627050</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Sampling and analysis</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Probable Hydrological Consequence</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/6/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>11/4/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$165.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500025195</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627050</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Sampling and analysis</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Field Tech Collections</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/6/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>11/4/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$120.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500025194</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627050</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Sampling and analysis</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Probable Hydrological Consequence(8415)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/6/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>11/4/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$82.50 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500025194</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627050</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Sampling and analysis</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Field Tech Collections</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/16/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/8/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$400.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500025345</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627050</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Sampling and analysis</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Water collection(U-3008-01DM5wv1019481</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/16/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/8/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$110.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500025345</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627050</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Sampling and analysis</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Field collection hours DM5</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/6/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/2/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$3,276.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500016083</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627060</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Open fork Deep Mine #5</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/9/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/6/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$4,446.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500016083</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627060</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>SECURITY/1129-120510/DM5</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/16/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/13/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$3,276.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500016083</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627060</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security DM5 BPO July>Dec</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/23/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/20/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$3,276.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500016083</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627060</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security DM5 BPO July>Dec</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/31/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/27/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$3,276.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500016083</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627060</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security DM5 BPO July>Dec</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/31/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>1/3/2011</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$3,276.00 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500016083</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>627060</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Security DM5</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20>PMM121006</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/31/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/31/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$109.50 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>637050</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Performance bonds</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Record December 2010 Performance Bond Expense</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71 height=20> </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/21/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl73>12/14/2010</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl74>$3,923.75 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>2111005</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>4500017761</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl72>650000</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Equipment rental</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #538dd5; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl71>Rent TL055 telehandler BPO July>Dec</TD></TR></TBODY></TABLE>

 

[Bigfille26]

Yeah I can give you a copy of my spreadsheet... A before showing the raw data and then the finished spreadsheet.... I'm unsure of where to upload it on this Forum though

 

[stnkynts]

Sorry, I forgot that on this forum you can't attach workbooks. I am used to another forum where you can.

While I am trying to figure out a way to get a copy of your spreadsheet what else do you need to have accomplished? Where do you want the totals to be on the sheet? Are we only doing this for sheet 9 or do we have to get this macro to work on all worksheets in the workbook?

 

[Bigfille26]

I just posted the spreadsheet on the ozgrid.com forum (my account name is the same on that forum also). There are two files that I attached. One is the "before spreadsheet", showing the data before anything has been done to it; The other spreadsheet is the "after", it shows the completed worksheet that I have been doing manually. This is how I was hoping to make my worksheets look. I was only able to include 3 tabs on each spreadsheet because of the file size limitation. Thanks again for the help and let me know of any questions. Here is the link to that posting with the spreadsheets:

http://www.ozgrid.com/forum/showthread.php?t=150090&p=539991#post539991