Code to prevent duplicate entries

Dear All,

I hope you are all well.

In a nutshell, I have a Master Workbook and 4 Child ones.

The Master has a CommandButton that collects all data from the Childs. No issues on that.

Now I am trying to add a code that prevents duplication of entries, but none worked so far.

The code on the Master to collect data from Childs is this one:

Please Login or Register  to view this content.

There are more codes similar to the above but I did not wanted to copy/paste all code.

Any ideas on how to set a code to prevent duplication?

Your assistance and/or advise will be highly appreciated.

Best regards,
Filipe

That's it Patel,

Graci / Thanks a million, really appreciated.

Best regards,
Filipe

Hi Patel,

Sorry to bother you again with this matter.

Your code worked perfectly for one sheet but I am using it for 3 of them.

I don't know if it's the amount of code that I used or the range I want to delete the duplicates.

For example, on your code, you have:

Please Login or Register  to view this content.

On mine, and due to the possible entries, I had to set the range as:

Please Login or Register  to view this content.

I am having an "Run Rime Error '28': Out of stack space"

Is there another code that can overcome the above mentioned error or is there another code that I can add on the code that I first posted instead on the "Worksheet_Change" event?

Your assistance on this matter will be highly appreciated.

Best regards,
Filipe

Sorry Patel,

One other thing, when I get the above error and click debug and run the code again without make any changes, it runs perfectly and clears the duplicates.

It might be something related to memory...

Cheers,
Filipe.