Hello, I am looking to create a VBA for a project where I have a start date In A1 and number of months in A2. I would like to be prompted for the start date and the duration ex,) 10 months. I would like it to auto fill the columns c1-c... with the dates.
Here is what I have been manually building and would like to streamline the process. Any help would be great
So essentially I say the number of months the phase is and in which months the phase should be completed. So for this one the start date is nov-16 and it is a 2 month phase so I go in and add the dates.
<colgroup><col><col><col><col span="12"></colgroup><tbody>
</tbody>
Here is what I have been manually building and would like to streamline the process. Any help would be great
So essentially I say the number of months the phase is and in which months the phase should be completed. So for this one the start date is nov-16 and it is a 2 month phase so I go in and add the dates.
| Project | Phase I - Base | Phase I - Option 1 | ||||||||||||
| Labor rate | Aug labor rates +….. | Aug 2017 Labor Rates + 2017 Proposed Provisional Indirect Rates | ||||||||||||
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||
| Date | Nov-16 | Dec-16 | Jan-17 | Feb-17 | Mar-17 | Apr-17 | May-17 | Jun-17 | Jul-17 | Aug-17 | Sep-17 | Oct-17 | ||
| Base Task 1 | ||||||||||||||
| # of Mos. | 2 | POP = Mos. 1-2 |
<colgroup><col><col><col><col span="12"></colgroup><tbody>
</tbody>
