Using VBA to Add Daily Change Orders to Budget

[wjmay1961]

I'm looking for some VBA help,

I have date values in Column A, Planned Budget Spend to Date in Column B (all on sheet1), and I would like to sum the daily change orders on sheet2 and add pass those values to Column C on sheet1 and sum those to the corresponding row (matching date).

<colgroup><col><col><col></colgroup><tbody>

Date	Cumm Plan $	Cumm. Plan + Change Orders
03/01/13	$1,102,041	$1,602,041
03/02/13	$2,204,082	$2,954,082
03/03/13	$3,306,122	$4,056,122
03/04/13	$4,408,163	$5,158,163

<colgroup><col style="mso-width-source:userset;mso-width-alt:2925;width:60pt" width="80"> <col style="mso-width-source:userset;mso-width-alt:4315;width:89pt" width="118"> <col style="mso-width-source:userset;mso-width-alt:5156;width:106pt" width="141"> </colgroup><tbody>
</tbody>

</tbody>

 

[justwitt]

Are you sure you need to use VBA for this.

If I understand correctly you just want to be able to show the Daily change order values on the first tab corresponding to the date in column A on the first tab. I would think that could be accomplished with a SumIf function.

If your tab name for the Daily Change Orders is "Daily Change Orders" and your dates are in column A and your sum is in column B on that tab then on your first tab in column C you would want (in row 2 for instance)
=Sumif('Daily Change Orders'!$A:$A, A2, 'Daily Change Orders'!$B:$B)

That would give that dates Daily change orders, if you want the value to be cumulative (year to date for instance) you could change it to

=Sumif('Daily Change Orders'!$A:$A, "<=" & A2, 'Daily Change Orders'!$B:$B)

 

[wjmay1961]

Thank you for your response, however there is more to this worksheet then what I posted. The Change notices on the project can exceed 500 in a month and each individual item and its value is logged on sheet 2. I have coding that runs the most current duration with the planned budget. It then looks at sheet2 and sums the daily totals and places them in Column D based on the matching day. Column C runs a cumulative daily total which sums the previous days+current change orders and all previous ones.. Also I have a graph which is using the offset feature to update based on the last row in the data set.

 

[wjmay1961]

I have included the spreadsheet showing the formulas

Date	Cummulative Plan $	Cumm. Plan + Change Orders	Daily AWR Values
41334	1102040.82	=SUM($G$13:G13)+D13	=VLOOKUP(C13,AWR_Log,2,FALSE)
41335	2204081.64	=SUM($G$13:G14)+D14	=VLOOKUP(C14,AWR_Log,2,FALSE)
41336	3306122.46	=SUM($G$13:G15)+D15	=VLOOKUP(C15,AWR_Log,2,FALSE)
41337	4408163.28	=SUM($G$13:G16)+D16	=VLOOKUP(C16,AWR_Log,2,FALSE)
41338	5510204.1	=SUM($G$13:G17)+D17	=VLOOKUP(C17,AWR_Log,2,FALSE)
41339	6612244.92	=SUM($G$13:G18)+D18	=VLOOKUP(C18,AWR_Log,2,FALSE)
41340	7714285.74	=SUM($G$13:G19)+D19	=VLOOKUP(C19,AWR_Log,2,FALSE)
41341	8816326.56	=SUM($G$13:G20)+D20	=VLOOKUP(C20,AWR_Log,2,FALSE)
41342	9918367.38	=SUM($G$13:G21)+D21	=VLOOKUP(C21,AWR_Log,2,FALSE)
41343	11020408.2	=SUM($G$13:G22)+D22	=VLOOKUP(C22,AWR_Log,2,FALSE)

<tbody>
</tbody>