Hi,
I have a schedule with many rows (rows are products) against which users input sales by month in columns. These sale amounts are then spread over a period (eg 12 months). See below 1,200 would be spread 100 per month for 12 months from Aug. The problem I am having is in trying to add to the 100 from another 50 per month for 12 months from Nov. I can do this in multiple rows and reconsolidate but I am trying to achieve a result on the same row against which the sales are entered.
<tbody>
</tbody>
I have a schedule with many rows (rows are products) against which users input sales by month in columns. These sale amounts are then spread over a period (eg 12 months). See below 1,200 would be spread 100 per month for 12 months from Aug. The problem I am having is in trying to add to the 100 from another 50 per month for 12 months from Nov. I can do this in multiple rows and reconsolidate but I am trying to achieve a result on the same row against which the sales are entered.
12 month Repay | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct |
Sales | 0 | 1200 | 0 | 0 | 600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
RePMT | 0 | 100 | 100 | 100 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 50 | 50 | 50 |
<tbody>
</tbody>