Macro to Populate cells in a column based on criteria

Hi,

Please find attached file and final result.

Thanks

And what is in L8?

if it is 9385 then in B2:

Formula:

=IF(SUM(B$1:B1)>=$L$8,"",MIN($F$2,$L$8-SUM(B$1:B1)))

and copy down

Of course this is just a formula, but macro (Worksheet_Change event handler looking for changes in F2 and/or L8) shall work the same way :-)

Thanks Kaper, you save my day.....