Macro works but I know there is a better way...

Simply put I needed a macro to check a set of data for duplicate records (via a unique id) and then concatenate all unique column items into one row -- all of the rows have the same column headers, just maybe different data in each row for a given column.

Here is what I came up with:

Please Login or Register  to view this content.

The problem is that column C, D, and E are dates and I keep getting ##### as one of the concatenates. I know it is a format issue, but I don't know how to solve it.

If you know of a better way or how to 'fix' this code, I would definitely appreciate the help

-Pwyller

What happens when you format them to date? Are concatenates dates separated by something?

sample.xlsm

Took a minute to sanitize the data... Run the macro (go button) and it will created the Combined tab...

When I format what to date? The original data is formatted as a date and when I tried

Please Login or Register  to view this content.

it threw an error...