First off, I am grateful I found this forum last night. What a wonderful resource. Thank you in advance! So with that said, I apologize in advance for any errors on this, my first post here.

Secondly, I spent a lot of time last night searching through previous posts about auto-populating and looking at many of the sample calendars that were posted through 2009-2012 and I couldn't find one that either fit my application/need or I could not adapt to my application/need. I'm an intermediate excel user and so my ability to adapt an existing calendar is limited due to the complexity of the formulas involved.

I thought my best bet was to use the Calendar-1.xls file previously posted in older threads due to it's simplicity and then populate basic data from my spreadsheet to populate. This would be a great resource for me, except that it doesn't account for multiple shipments on one singular date. I am trying to minimize the time I spend manually populating a calendar as I do this for two suppliers (one domestic and one international).

Can someone help me adapt my data (Column A & column D & Column E) to the Calendar-1.xls file (or one better suited for my application) making sure that multiple shipments appear on their respective dates ("Must ship by" Column H)? Any help that can be afforded to me, would be greatly appreciated!

Sincerely,
WatercolorarteestCalendar-1.xlsSampleShipmentData.xls