Help with re-working macro code to 'throw out' duplicate values.

[pwyller]

The following Macro will use column A as a key and merge subsequent rows into one row on a new sheet:

Key Data1 Data2 Data3
1 Red Blue Green
1 31 32 33

Becomes:

Key Data1 Data2 Data3
1 Red,31 Blue,32 Green,33

However, if all Key 1 rows have the same info in Data1:

Key Data1 Data2 Data3
1 Red Blue Green
1 Red 32 33

It becomes:

Key Data1 Data2 Data3
1 Red,Red Blue,32 Green,33

What I'd like is to only 'copy' one instance of a duplicate value in each column and end up with:

Key Data1 Data2 Data3
1 Red Blue,32 Green,33

Okay I solved that, now I can't figure out why it copies '######' into the new sheet now and doesn't seem to work on large files...

I solved the '######' problem, but it still crashes on a large file 500k records...

Please Login or Register  to view this content.