Concatenate fields into calendar date

I can't find any code in the workbook for concatenating the data you mention.

Where should I be looking?

I apologize for the confusion, the error that was coming up was fixed because of a compile error but the file that I uploaded is not pulling the correct data on the calendar from the 'Details' tab. I would somehow like to have the information on the calendar be from multiple columns instead of just the first column. Hope this helps. Thanks again.

You do know that the dates aren't being populated correctly?

It appears to be a one or two of days out here and there.

I borrowed your sheet and came up with the attached.

I've tested it for 2013 and a few months in 2014 and everything seems to be right.
WorksheetCalendar.xlsm

Thanks again for the correction on the calendar, i'm really trying to get all my data from my detail page to the calendar and its both incorrect and I would really like to concatenate from multiple columns. I can give you credit for my other question relating to the calendar:

https://www.experts-exchange.com/questions/28142462/Calendar-is-not-populating-dates-on-the-correct-day.html?anchorAnswerId=39206774#a39206774

Cheers, was getting a bit confused where to post.

So you still need help with filling out the details in the calendar?

What's to be done with this concatenation?

Has it to be displayed somewhere?

What if there is more then one business with the same Cal Type ID on the selected date?

Yes it has to be displayed on the calendar with the coinciding dates from column B in Details tab. I have column A already displayed on the calendar.

Ah, right instead of just the ID (column A) you want to show the other columns on the calendar.

Yes that is correct. I realized that in column A i had to put a unique identifier in order to show the information correctly in the calendar. It was evidently just showing the first or second row and not looking down the entire spreadsheet. So you are correct. I want to show the other columns in the calendar. Headings to be selected are "Business Name"+"QTY"+"Estimated Ship Date". Thanks

I uploaded an updated file which I'm using.
CalendarConcatenate.xlsm

I've believe the attached file will create the calendar with the fields concatenated as requested.
CalendarConcatenate.xlsm

Thanks buttersk. It looks good, I think I can figure out a way to have the ampersand and index number to be invisible but I noticed that the popup form does not work anymore.

The pop up quit working because we changed what is displayed in the calendar.

If you look at the code for Sheet4 (Project-Calendar New),  there is an event triggered call "Worksheet_SelectionChange".

Whenever you select a different item on the calendar this function / event is fired.   One of the first things this subroutine does is to take the contents of the cell and checks to see if it can find a match for the contents of the calendar cell, in the Detail worksheet.

Since the calendar now contains something like "AMG&4 1300 04/17/2013"... there is no match for that string on the detail page.

I've changed your search routine in the Project Calendar new sheet.

It takes the string  value from the selected calendar cell ... "AMG&4 1300 04/17/2013" for example and splits it at the blanks... and assign to an array called subWord so that you end up with this:

subWord(1) = "AMG&4"
subWord(2) = "1300"
subWord(3) = "04/17/2013"

With those values the search routine will start a the top of the Detail sheet and examine each row.

If
Column1 = subword(0) and
Column6 =  subword(1) and
Column12 = subword(2) then

We will consider that a "Found" row on the pop up.

Currently If and only if you find a matching row within the Detail sheet will the pop up be displayed with the data from the matching detail row.
CalendarConcatenate--2-.xlsm

After displaying the comboBox... noticed that there were some error's that needed to be cleaned up if you pick a blank cell in the calendar or if date doesn't exist on the detail sheet.

The attached version should correct those errors as well.
CalendarConcatenate--2-.xlsm

Pretty darn good stuff buttersk. I added some changes but all in all an awesome answer. Much respect.

Made in error