Help creating a Macro for combining data on dup records

[lwilt]

I have a spreadsheet of customer data, email address, customer number, and products they've purchased, and the file is about 200K row records. The emails can be tied to multiple customer numbers so I am trying to combine the data for products purchased at the email level that way every email only appears on one row line and it has all the items purchased for that email even if that email is tied to more that one customer number.

please help me create a Macro to do this....I tried using a countifs but excel kept crashing on me.

[walruseggman]

You need to provide a sample data sheet, and please show both what your raw data looks like, and what you want it to look like after the macro runs. Doesn't have to be a huge data set, just a few examples that mirror the formatting of your spreadsheet.

[lwilt]

How do I include a file to upload it? I couldn't figure that out and I just joined the forum

[lwilt]

Ok I think it's attached. the yellow highlights show the dup emails and how I need them combined

[jaslake]

Hi lwilt

This Code is in the attached and appears to do as you require...please notice...I've changed the Name of Sheet1 to Input...

Please Login or Register  to view this content.

[lwilt]

Thanks man that worked like a champ...you are a genius sir. I realized afterwards that some of the dup emails were from case errors so I will just need to change it all to one case before running the macro. being a new user I'm sure how to mark this thread as solved...

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.