Finding duplicate values in 5 excel sheets and results to be moved in the sixt one

Question

I'm attempting to identify duplicate values across five separate sheets, colour them, and move the findings to the sixth empty sheet while also identifying the sheet from whence the value was taken. I'll provide an example: Five of my direct marketing campaigns are different. The sheet is titled "Cam 1, Camp 2," which is also the name of the campaign. I keep the client ID information, which is a 10-digit number, on each sheet. In order to prevent customer duplication, I would like to filter duplicate IDs (from each page) and transfer them to a separate blank sheet along with the information from where the customer ID was taken. There are other formula combinations, but I'd prefer to utilise macros, as each campaign has 200K or more IDs and using a formula, is quite time-consuming and not always successful.

I anticipate discovering even more simple solutions for this task.

Answer 1

See this article: VBA duplicated values coloring. I hope this helps you.