How to pull values from other cells, up to a limit.

[TinyDamooge]

Hi all,

See the attached spreadsheet.

There are values in the first row (row 5),

and the second row (row 7) money if pull from the first row for each month, up to a limit of £5000, where it and from then on it pulls nothing.



Rather than do this myself is there a formula I can use to apply to all the cells in the second row (row 7) so I can change the first row (row 5) and it would automatically work out when I can stop pulling money from it as I am at the limit.

I do this by hand so it would be nice to automate.


Ta for any help!