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

#### lgerick

##### New Member
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
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
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-comfficeffice" /><o></o>
Sorry, I should have been clearer.

MONTH is Column A ARRIVED is Column B LEFT is Column C TOTAL is Column D
<o></o>
OCTOBER is in ROW 2<o></o>
NOVEMBER IN row 3 <o></o>
AND SO ON. {see the example below}<o></o>
<o></o>
The reason for =237+B2-C2 in cell D2 is the year started with 237 Arrivals<o></o>
<o></o>
So 237 plus new arrivals less those leaving in C2 to = D2 Months end totals<o></o>
<o></o>
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></o>
<o></o>
then DEC. on Dec 1st and so on. <o></o>
<o></o>
so that the TOTAL AT MONTH END is not carried down automatically, but only when that month opens. <o></o>
<o></o>
<o></o>
<o></o>
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></o>
<o></o>
hope this makes sense. I am self taught and still learning as I go <o></o>
<o></o>
thanks for responding.<o></o>
<o></o>
lgerick

<o></o>

<o></o>
<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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

</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></o>

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

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

### 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...