Concatenate a calendar

[jeffmfrank]

I'm trying to create a calendar that uses a database type of list of events and concatenates a text string of 5 cells in one row associated with the event to drop the into the proper day in a calendar. I'd like the calendar to be in the same workbook. The challenge I face is getting multiple events entered into the list to automatically populate the calendar. A vlookup isn't any good because the dates in the list will not be in order and there will be multiple entries for single days. Any suggestions on how to approach?

 

[Andy Gee]

Maybe use validation ranges, indirect and offset. With more info I may be able to tell you more