Sorry Andman, I used the wrong starting range in my formulas. Row 3 should
be the helper row, and start placing the formulas in A3 and B3 as such:

A3: =IF(A2A1,A1,A2)

B3: =IF(A3<A2,0,IF(SUM($A$2:B2)<=$A$1,B2,$A$1-SUM($A$2:A2)))
and copy this through P3

HTH

Bruce

"swatsp0p" wrote:

Hi, Andman. I'm not sure if JulieD is around, so I'll jump in. Without VBA,
you can't have a formula change the contents of another cell. You can,
however, use a helper row to accomplish your task. In C2, place this
formula:
=IF(C1A1,A1,C1)
then in D2 place:
=IF(C2<C1,0,IF(SUM($C$1:D1)<=$A$1,D1,$A$1-SUM($C$1:C1)))
copy this formula through P2