Find duplicates, copy one of each to another sheet

[Jele007]

Hi!
I'm supposed to find duplicates in sheet_1 Q6:Q251 and copy one of each to sheet_2 D6:D243 as well as unique values from the same column.
In a sheet_1 B6:B251 I have values related to Q6:Q251 and I have to copy each of them to sheet_2, E6:I6 in the same row as the related duplicate (I'll have max 5 duplicates).
Is this even possible?
You can find attached simple example of what should be the result (sheet_2)

Thank you in advance!

[natefarm]

It shouldn't be a problem, but I find your request unclear, and the data in the attachment doesn't match up with anything you are talking about.

[Leith Ross]

Hello Jele007,

The attached workbook contains the macro below. A button has been added to "Feuil1" to run the macro.

Please Login or Register  to view this content.

[Jele007]

I have some confidential data and I can't attach the original file, but here is a part of it (modified)
I'll try to be more clear: I have to copy values from sheet_1 column R in sheet_2 column D, but without repeating the duplicates. I should copy as well unique values as you can see in the attached file. In sheet_1 column G I have values related to column R and these values should be copied to sheet_2. How in sheet_1 I want to have only one copy of each duplicate the values from G should be copied in the same line in sheet_2 (from E6:I6, cos I'll have max 5 duplicates).
Sheet_2 is what normally I should obtain automatically...
If it's still not clear just say...

[Jele007]

@ Leith Ross

Thanks a lot, I'm gonna try immediately

[Jele007]

@ Leith Ross

Not working in my original file don't know why

[Leith Ross]

Hello Jele007,

The macro was written based on the example you posted. If the workbook the macro is installed in is different from the posted workbook then the macro will need to adjusted for that workbook. To make the adjustments I would need to see the workbook you are currently using.

If the workbook contains sensitive data then you can create an expurgated copy for posting. If that is not satifiactory then the only other option would be emailing me a copy for review.

[Jele007]

Hello everyone,

I'm STILL struggling with this code. Leith solved the problem but I don't understand the code enough to apply it on my original workbook. I've tried to change the names of the sheets and the range of columns but it's not working. This time I attached the blank workbook, same as the one I use. The data I have to copy is on the sheet 'SUIVI_DEVIS'. Duplicates are in the column Q and related data in the columns F and R. All this should be copied to sheet 'ORDRES DE SERVICE' (as you can see I've entered data manually, after entering the code I should obtain all that directly). I would really really appreciate if someone could help me!