Locating Duplicates in a range

[AppSupportKarl]

Hello everyone,

i'm currently developing a macro to help Check the data of a file we would be importing.

one of the columns i need to check contains the additional reference for our customers. i need to search this range to find the duplicates, thenn copy and past the data into a second sheet if it is found to be a duplicate. i have used the below code before to find a data item in a range, but don't know if it can be modified to find duplicates?

Please Login or Register  to view this content.

whereupon, a 'nothing' would produce a message to the user

[arlu1201]

Attach your spreadsheet and we can help you.

[AppSupportKarl]

bookoncheck.xlsI wasn't going to, due to complexity making it more convoluted than needs be, but here you go!

the column additional reference (E) needs to be checked one at a time, and if a duplicate is found in the same column and the column "record type" (B) for both / all is a P, then it needs to highlight the cell yellow, i can program the rest from there.

Apologies in advance for the clunky nature of my code, i'm a gaffer tape kind of guy!

[arlu1201]

Use this code. Put in a blank module of your workbook. I guess you already know where to find it.

Please Login or Register  to view this content.