Hi, I would like to seek your help in this problem,
I have cell "U6" that caluclates a deficit or surplus based on a value entered on another cell "B6" now what i do is enter values manually in cell "B6" till te value in "U6" reached zero. but when dealing with a range of cell, its time consuming to enter values manually, so I though of using Porblem solver, it worked fine, but it works on one cell at a time, again it is time consuming.
what i am looking for is a formula that changes values of cell "B6" untill "U6" is zero, then i can apply to the rest of cells (B6:B5000) ?

Hope somebody can help me with that

Thanks in advance
Joenash