I need a macro to do exactly what the tittle says. If there are duplicate dates in column B, I want to combine the text in column C. For example B1, B10 and B18 all have the date 12/25/12. Column C1, C10 and C18 read A,B and C, respectively. I want to output the Date(12/25/12) in Column D1 and the value "ABC" in Column E1. It will need to loop through the entire column A. Should be fairly simple, but I am stuck....