Data Organization and Calendar Pulling in Multiple Events per Day

Good Morning!

This is my first time posting, and joined yesterday, but I have lurked for a quite a while on this website. I am seeking some help for my first post.

I am working on a predictive calendar based upon some standard times for given processes. My current build is as follows:

1. Tab #2 has a list of given lots that will have upcoming deliveries. I have standard days manipulating dates and then displaying the anticipated results in their own column. I have these grouped so they can be collapsed and are organized by different communities.

2. I am then taking these dates and attempting to have them show up visually on a calendar for quick reference. This will be utilized for load balancing.

Current Issues:

1. I cannot get the dates to show up as anything but a generic text that is currently "Shipment". I would like the dates to correspond with the given value in column B, and even include the community headings in column A.

2. I cannot get more than one occurrence to show on a single day. There may be instances where up to 10 could co-exist at once.


Thank you for any help, ideas, and any knowledge gained!