Hey guys,
First post here so please forgive me if I miss anything..
I am new to VBA and attempting to find some coding that will allow me to allocate the below section units between months based on course start and end dates.
I have entered a couple of lines below of what I'm working with. It is the values in bold that I would like to have automatically generated if possible, as this needs allocating over a 12 month period for over 5,000 course offerings.
The top row denotes the columns that are currently being used, but the dates currently run from Apr18 in column Q to Mar19 in column AB as shown.
<tbody>
</tbody>
If anyone is able to offer any help that would be greatly appreciated!!
Kind regards
Liam
First post here so please forgive me if I miss anything..
I am new to VBA and attempting to find some coding that will allow me to allocate the below section units between months based on course start and end dates.
I have entered a couple of lines below of what I'm working with. It is the values in bold that I would like to have automatically generated if possible, as this needs allocating over a 12 month period for over 5,000 course offerings.
The top row denotes the columns that are currently being used, but the dates currently run from Apr18 in column Q to Mar19 in column AB as shown.
H | I | J | N | V | W | X | Y | Z | AA | AB |
Course Meet Date | Course End Date | Course Length (Days) | Section Units required | Sep18 | Oct18 | Nov18 | Dec18 | Jan19 | Feb19 | Mar19 |
7-Jan-19 | 31-Mar-19 | 84 | 2 | 0.6 | 0.67 | 0.74 | ||||
4-Sep-18 | 14-Dec-18 | 102 | 20 | 5.29 | 6.08 | 5.88 | 2.75 |
<tbody>
</tbody>
If anyone is able to offer any help that would be greatly appreciated!!
Kind regards
Liam