I need to figure out how to enter data fro column b and then subtract that from column a and enter the new value, then keep that going to formulate each days target for the whole month

So if cell a1 is 105 and b1 has a goal of 33 a day then c1 is 33.
Then c2 and c3 would need to also be 33
Then c4 would be the 6 remaining plus the goal from b2


So a2 would be 19 and b2 would be 27
And so forth

How did you arrive at 19 as the value for A2? is A2 dependant from the values of the other cells areas? You said c4 is equal to 6 plus B2 or 27 so c4 value is 33, right?

Sorry column a would be the order amounts which i would put in at the begining of the month. Column b will be a lookup for the daily output possible from the order amount in column a. That is all done and working. Column c is my issue. It needs ro be the target set for each day

Let's wait for the experts to provide the solution. It's not the regular IF and SUM operations because my understanding is the daily goal (column c) remains static until the first order had been filled, any remaining balance (first order less accumulated goal in Col C) will then be added to the next goal in column B.

@dawindle
Hi and welcome
please post a sample sheet with some data and expected results
( click Go advanced - Manage attachments)
Thank you

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post