How to get the payment automatically filled

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm working with an income statement. I want to record the money that I received from my customer into each month of the year. But there are different payment mode: single, monthly, quarterly, semiannual and annual. What I want is:

For example customer wants to pay for the sum of $100 semiannual (2 times a year) and the first payment of $50 is made in June. The next payment of $50 will be made in December. My question is how I have the payment automatically divided by 2 and added in to the June and December ?

this is how the worksheet may look like:

Sheet1: When I Fill in all the information in this page

Name Month receive Payment amount Payment mode
A June $100 semiannual

Sheet2: I will have this page automatically done like this

Sum of the Payment receive in month

month 1 2 3 4 5 6 7..... 12


$50 $50




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can get some idea from here
https://ccm.net/forum/affich-175692-mirror-cells-two-ways-different-cells