Help with Pulling in List to copy Dates

urkas

New Member
Joined
May 11, 2010
Messages
19
Office Version
  1. 2019
  2. 2016
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

ItemDate
301080.019/1/2019
301080.0110/6/2019
301080.0111/3/2019
301080.0112/1/2019
301080.011/5/2020
301080.012/2/2020
301080.013/1/2020
301080.014/5/2020
301080.015/3/2020
301080.016/7/2020
301080.017/5/2020

<colgroup><col span="2"></colgroup><tbody>
</tbody>
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Hi Urkas,

Don't really understand what you require.

What i think you want is:
For each partnumber in the list create a table with the partnumber in the first column and a list of dates (first sunday of the month) in the 2nd column.

Do you want a sepearte list for each part number or do you want these below each other?

As an alternative:
Why not use a table with partnumbers in the left column and dates in the top row?
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,949
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top