Trying to find duplicate, copy and paste certain unique values, and remove the duplicates

Hello, Thank you for your time and expertise in advance.
I have a workbook that uses a macro to aggregate attendance data from several other workbooks - the workbook is attached. I would like to use the email address column to search for duplicates, copy and paste attendance information, and then delete the duplicate row (and repeat this several times for each email address).

With the code I have come up, which may be considered beginner, I am getting this error:

1. Error comes up saying "Object required" (in the section highlighted)

I would really appreciate someone pointing me in the right direction (for me to change the code) or posting corrected code.

Please Login or Register  to view this content.

Welcome to the board!

In the future, please fill in your sample sheet with data. We're already busy and don't have time to try guess at a data set.

Replace this section.

Please Login or Register  to view this content.

Because your data was all the same, I still had to modify it so I could test it.

You can easily fill a column with unique data by using the column header along with row.

Please Login or Register  to view this content.

will return FirstName1. Drag down and you're done. Repeat as required for other columns.

Please Login or Register  to view this content.

@ Jele007, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

At the bottom, add these two lines.

Please Login or Register  to view this content.