Auto-populating calendars using excel - marketing purposes

Here is a modified file.

The drop-down was due to the fact I had inserted a bunch of rows. This calendar originally was meant for only one item per day. I had added the rows to suit your request of multiple items, and I forgot that the drop-down's source data was on the same sheet.

I added in the ability to concatenate more data columns into the cell. To do this, I inserted some helper columns for each day of the week. This helper column is used to calculate the row number. Then INDEX uses that row number to grab the data. I did it this way so that the workbook wouldn't need to calculate the row number multiple times (once per data column you wanted displayed)

awesome....just what I was looking for too...
thanks a bunch