Urkas
New member
- Joined
- Sep 25, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2010
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
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
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