Combining Rows - Keeping Unique and "New" Values & Merging Duplicate Values

I am in need of quite a bit of help. I do not know VBA, and I don't think I'll be able to figure out what I need to do on my own.

I have a huge spreadsheet that is temporarily storing "member" information. I have quite a bit of semi-duplicate data.

Example
123456 | jane.smith@site.com | Jane | Smith | | Single <-- Older Record
258369 | jane.smith@site.net | Jane | Smith | Houston | Married <-- Newer Record

So, I need these rows combined: keeping the duplicate data and updating with the "newer" data (on the bottom row), but keeping the USERID with the smaller number.

Result
123456 | jane.smith@site.net | Jane | Smith | Houston | Married

Is this even possible? I am assuming if it is that I would need VBA code or a macro.
Otherwise, I have to do this all by hand - which is currently 600+ rows of data to fix. Out of 11,000+ rows, it's not horrible, but who wants to do this by hand?

Can anyone help me out?

How will this new macro determine rows that are truly a match? Certainly in 11,000 rows of data there could be two Jane Smith's that weren't the same person. If the macro is merging new data up into old rows except for just the first and last name fields, I'd wonder if real individuals are disappearing in the process.

Can you provide a sample workbook with the exact data layout and 10-20 rows of sample data to test a suggested solution on?

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

This should do it:

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Thanks for your work. This codes did work on the sample I gave you, but it's not working for the entire database.
I'm inserting a module -> pasting the code & running it. It processes, but very few of the records are merged. I have 689 rows total and the subroutine only gets it down to 635. Am I using the code incorrectly or is something wrong?

Scratch that! It was a mistake on my part. Thank you, thank you!