Find Duplicates & Move Data Based on its criteria

Hi,

I have some knowledge of VBA but not enough to manipulate the data i want in this instance.

I need to do a few things....

I work for an online company taking booking via the internet. I need to take out the duplicate email address but put the additional duplicated information in the in the correct columns based on Month & Value. I also want to move the information in Columns B - C to the correct columns based on mont and value. I have attached a before and after of what im trying to achieve. I have 600,00 email address hence why i don't want to do it manually. My ultimate goal is to report retention rates.

Columns A - C are raw data
Capture.JPG
Thanks in advance!

Greetings,

Attached is a file containing a macro that does what you want. (Sorry that no one's gotten back to you before this.)

Please note that I'm sure there is a typo in your example jpg. The example jpg image lists 454 bookings for that second e-mail address ("[email protected]") and I'm sure that should only be ONE booking. Also, I'm sure the February VALUE for this guy should be 454 instead of 2.

Besides that, which confused me for a moment, I understood your graphic.

I'm sure you want this carried out for 12 months, correct?

The macro will continue for as many records as you have, until it comes to the first empty cell in column A.

For now, the macro is set up to be run when the button is clicked, but you can change that if desired. Finally, note that for now, there is no error checking to see if the values are numeric or not.

Please test and let me know if this works for you.

bookings macro.xlsm

Update. If you have THAT many e-mail addresses, then use this file instead. (It will fun faster.)

(Application.ScreenUpdating = false.)

bookings macro - modified.xlsm

Assming data is in Sheet1, starting from A1(heading)

Please Login or Register  to view this content.

Thanks Ed! This perfect and will save me so much time. Really appreciate your help!

Thanks agin