I have a set number of dates that I need to forecast. Some of the months I have dont always have a Forecast but I want to be able to at least post a 0 still in that date.
What I need is to be able to use a list of parts IE
301080.01
301081.01
301082.01
301083.01
Etc ( this parts will be somewhat all over the place as part as how they may look )
And from there I want to have them formatted as follows.
And just have this repeat through all the parts I have listed.
Ideally I would want to be able to set my Range at the top of this Excel sheet
IE two cells - Start and End Date
<colgroup><col span="2"></colgroup><tbody>
</tbody>
What I need is to be able to use a list of parts IE
301080.01
301081.01
301082.01
301083.01
Etc ( this parts will be somewhat all over the place as part as how they may look )
And from there I want to have them formatted as follows.
And just have this repeat through all the parts I have listed.
Ideally I would want to be able to set my Range at the top of this Excel sheet
IE two cells - Start and End Date
Item | Date |
301080.01 | 9/1/2019 |
301080.01 | 10/6/2019 |
301080.01 | 11/3/2019 |
301080.01 | 12/1/2019 |
301080.01 | 1/5/2020 |
301080.01 | 2/2/2020 |
301080.01 | 3/1/2020 |
301080.01 | 4/5/2020 |
301080.01 | 5/3/2020 |
301080.01 | 6/7/2020 |
301080.01 | 7/5/2020 |
<colgroup><col span="2"></colgroup><tbody>
</tbody>