Concatenate Between Entries

[billykiller05]

I have the following list. I need a way to concatenate the dates between the new entry(s). The number of dates can vary between new entries.

New Entry
9/2005
10/2005
11/2005
New Entry
9/2005
10/2005
11/2005
New Entry
9/2005
10/2005
11/2005
New Entry
6/2006
7/2006
New Entry
6/2006
7/2006
New Entry
9/2006
10/2006
New Entry
12/2006
1/2007
New Entry
3/2007
4/2007
New Entry
3/2007
4/2007
5/2007
New Entry
4/2007
5/2007
6/2007
New Entry
4/2007
5/2007
6/2007
7/2007
New Entry
5/2007
6/2007
7/2007
8/2007
New Entry
5/2007
6/2007
8/2007
9/2007
New Entry
5/2007
6/2007
8/2007
9/2007
New Entry
6/2007
8/2007
9/2007
New Entry
6/2007
8/2007
9/2007
12/2007
New Entry
6/2007
8/2007
9/2007
12/2007
01/2008

[mrice]

This macro will create a comma separated concatentated list in column C.

Please Login or Register  to view this content.

[billykiller05]

I copied and pasted the macro but it keeps hanging up on the line below.

Cells(Counter, 3) = Cells(Counter, 3) & Cells(L, 1) & ","

[mrice]

Should be N not L as in the original reply.

Does this help?

[billykiller05]

I have attached my file. I would like a formula or a macro which can concatenate the mo/year between "New Entry" cells and enter the values in column E beside the "New Entry" cells as I manually did in cell E1 and E5.

[Bjornar]

Try this code:

Please Login or Register  to view this content.

[billykiller05]

That works awesome. Thank you so much for your help.