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

0 votes
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.
Feb 10 in Others by Kithuzzz
• 34,760 points
50 views

1 answer to this question.

0 votes

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

answered Feb 10 by narikkadan
• 59,740 points

Related Questions In Others

0 votes
1 answer

Excel VBA- How to loop through specific sheets in a workbook and format the same ranges in each sheet

Range(...) instructs VBA to always use the ...READ MORE

answered 6 days ago in Others by Kithuzzz
• 34,760 points
35 views
0 votes
0 answers
0 votes
2 answers
0 votes
1 answer
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
575 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,548 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 22,970 points
148 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
391 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 59,740 points
343 views
0 votes
1 answer

How to format numbers as lakhs and crores in excel/ google spreadsheet when the number could be negative too?

Excel formatting, in my opinion, can only ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 59,740 points
2,961 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP