Hi to all of you, kindly require to provide me support for a VBA code so that, to allocate the amounts in row “15” based on range of period (rows “10” & “11” into adjacent below cells for each month. Therefore, that the rows are stably but the range of columns are not but no more than 60. Please see below an extract of original data and expected results. Thank you all in advance
Original data
A | B | C | D | E | F | G | |
10 | RANGE OF PERIOD | 10/4/2019 | 25/5/2019 | 1/10/2019 | 8/4/2019 | 31/5/2019 | 2/10/2019 |
11 | 25/4/2019 | 2/10/2019 | 31/10/2019 | 30/5/2019 | 1/10/2019 | 24/10/2019 | |
12 | DAYS DURATION | 16 | 131 | 31 | 53 | 124 | 23 |
13 | DAILY RATE | 125.36 | 110.74 | 95.56 | 85.46 | 121.25 | 90.78 |
14 | NO OF PERSONS | 2 | 2 | 2 | 2 | 2 | 2 |
15 | TOTAL | 80,230.40 | 1,160,555.20 | 118,494.40 | 63,411.32 | 300,700.00 | 29,231.16 |
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | APRIL | ||||||
21 | MAY | ||||||
22 | JUNE | ||||||
23 | JULY | ||||||
24 | AUGUST | ||||||
25 | SEPTEMBER | ||||||
26 | OCTOBER | ||||||
27 | NOVEMBER | ||||||
28 | TOTAL | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
<tbody>
</tbody>
Expected result
A | B | C | D | E | F | G | |
10 | RANGE OF PERIOD | 10/4/2019 | 25/5/2019 | 1/10/2019 | 8/4/2019 | 31/5/2019 | 2/10/2019 |
11 | 25/4/2019 | 2/10/2019 | 31/10/2019 | 30/5/2019 | 1/10/2019 | 24/10/2019 | |
12 | DAYS DURATION | 16 | 131 | 31 | 53 | 124 | 23 |
13 | DAILY RATE | 125.36 | 110.74 | 95.56 | 85.46 | 121.25 | 90.78 |
14 | NO OF PERSONS | 2 | 2 | 2 | 2 | 2 | 2 |
15 | TOTAL | 80,230.40 | 1,160,555.20 | 118,494.40 | 63,411.32 | 300,700.00 | 29,231.16 |
16 | |||||||
17 | |||||||
18 | |||||||
19 | |||||||
20 | APRIL | 80,230.40 | 27,518.12 | ||||
21 | MAY | 62,014.40 | 35,893.20 | 2,425.00 | |||
22 | JUNE | 265,776.00 | 72,750.00 | ||||
23 | JULY | 274,635.20 | 75,175.00 | ||||
24 | AUGUST | 274,635.20 | 75,175.00 | ||||
25 | SEPTEMBER | 265,776.00 | 72,750.00 | ||||
26 | OCTOBER | 17,718.40 | 118,494.40 | 2,425.00 | 29,231.16 | ||
27 | NOVEMBER | ||||||
28 | TOTAL | 80,230.40 | 1,160,555.20 | 118,494.40 | 63,411.32 | 300,700.00 | 29,231.16 |
<tbody>
</tbody>
Last edited: