need help with macro or formula that will sum cells on the 1st day of the month

lgerick

New Member
Joined
Oct 8, 2008
Messages
25
Hello,

I'm trying to write a macro or formula that will sum the following
=(D2+B3)-C3
on the first day of the month.
I need this for each month.
Each month will change, so for
October 1 2008 I need it to sum =237+B2-C2
November 1 2008 I need it to sum =(D2+B3)-C3
December 1 2008 I need it to sum =(D3+B4)-C4
January 1 2009 I need it to sum =(D4+B5)-C5
and so on through September of 2009

I am really struggling with this and would so appreciate any help you can give.

Thanking you in advance [and will most definitely thank you again and again]

lgerick :)
 

schielrn

Well-known Member
Joined
Apr 4, 2007
Messages
6,934
How is your data laid out? You haven't given us to much to work with because the formula you have can just be drug down and the cell references should change to the one you have in the sequence, so I must be missing something?
 

lgerick

New Member
Joined
Oct 8, 2008
Messages
25
How is your data laid out? You haven't given us to much to work with because the formula you have can just be drug down and the cell references should change to the one you have in the sequence, so I must be missing something?


<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
Sorry, I should have been clearer.

MONTH is Column A ARRIVED is Column B LEFT is Column C TOTAL is Column D
<o:p></o:p>
OCTOBER is in ROW 2<o:p></o:p>
NOVEMBER IN row 3 <o:p></o:p>
AND SO ON. {see the example below}<o:p></o:p>
<o:p></o:p>
The reason for =237+B2-C2 in cell D2 is the year started with 237 Arrivals<o:p></o:p>
<o:p></o:p>
So 237 plus new arrivals less those leaving in C2 to = D2 Months end totals<o:p></o:p>
<o:p></o:p>
Then on NOVEMBER 1st I would like it to auto sum =(D2+B3)-C3 which is Octobers totals plus Nov.s new arrivals less Nov.'s leaving.<o:p></o:p>
<o:p></o:p>
then DEC. on Dec 1st and so on. <o:p></o:p>
<o:p></o:p>
so that the TOTAL AT MONTH END is not carried down automatically, but only when that month opens. <o:p></o:p>
<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
the amounts in cells B2:B13 and C2:C13 are retrieved automatically from another sheet in the workbook as such. B2 ='OCTOBER 08'!E9.<o:p></o:p>
<o:p></o:p>
hope this makes sense. I am self taught and still learning as I go :)<o:p></o:p>
<o:p></o:p>
thanks for responding.<o:p></o:p>
<o:p></o:p>
lgerick


<o:p></o:p>

<o:p></o:p>
<TABLE style="WIDTH: 266pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0in 0in 0in 0in" cellSpacing=0 cellPadding=0 width=355 border=0><TBODY><TR style="HEIGHT: 38.25pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 67pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt" vAlign=bottom noWrap width=89>
MONTH<o:p></o:p>







</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt" vAlign=bottom width=75>
Arrived<o:p></o:p>







</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt" vAlign=bottom width=91>
Left<o:p></o:p>







</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; WIDTH: 75pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt" vAlign=bottom width=100>
Total at End of Month<o:p></o:p>





</TD></TR><TR style="HEIGHT: 24.75pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>OCTOBER<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
6<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
7<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=237+B2-C2">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap>NOVEMBER<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num x:fmla="=(D2+B3)-C3">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>DECEMBER<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D3+B4)-C4">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap>JANUARY<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num x:fmla="=(D4+B5)-C5">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>FEBRUARY<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D5+B6)-C6">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 27pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 27pt" vAlign=bottom noWrap>MARCH<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 27pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 27pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 27pt" vAlign=bottom noWrap x:num x:fmla="=(D6+B7)-C7">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 24.75pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>APRIL<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D7+B8)-C8">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 25.5pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap>MAY<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num x:fmla="=(D8+B9)-C9">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>JUNE<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D9+B10)-C10">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 25.5pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap>JULY<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num x:fmla="=(D10+B11)-C11">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 25.5pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>AUGUST<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D11+B12)-C12">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap>SEPTEMBER<o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num x:fmla="=(D12+B13)-C13">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt" vAlign=bottom noWrap rowSpan=2 x:num x:fmla="=SUM(B2:B13)+237">
243<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt" vAlign=bottom noWrap rowSpan=2 x:num x:fmla="=SUM(C2:C13)">
7<o:p></o:p>





</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt" vAlign=bottom noWrap rowSpan=2 x:num x:fmla="=SUM(B14-C14)">
236<o:p></o:p>





</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>TOTALS<o:p></o:p>


</TD></TR><TR style="HEIGHT: 6pt; mso-height-source: userset"><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num="39730" x:fmla="=TODAY()">
10/9/2008<o:p></o:p>





</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD></TR><TR style="HEIGHT: 13.5pt"><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


</TD></TR></TBODY></TABLE>​
<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
 

Forum statistics

Threads
1,082,017
Messages
5,362,695
Members
400,686
Latest member
Aakash

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top