hey,
I have been struggling with this one.
I prepared a whole workbook for managing cash flow.
in one of the sheets I have a table for each month and there you can see revenue costs etc.
sometimes customer pays in payments and so I gotta find a way to make it pass from one table to another knowing how much the remainder is.
for example, a customer with 2 payments so in January I will have half the total amount and in February the rest. if he paid in three payments then March would be the end.
the table:
every row is the same product in the same order, and price and quantity are taken from another table that the user is filling. he only controls the payments.
really hope someone can help me out here.
thank you in advance
I have been struggling with this one.
I prepared a whole workbook for managing cash flow.
in one of the sheets I have a table for each month and there you can see revenue costs etc.
sometimes customer pays in payments and so I gotta find a way to make it pass from one table to another knowing how much the remainder is.
for example, a customer with 2 payments so in January I will have half the total amount and in February the rest. if he paid in three payments then March would be the end.
the table:
every row is the same product in the same order, and price and quantity are taken from another table that the user is filling. he only controls the payments.
really hope someone can help me out here.
thank you in advance
