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, 2023 in Others by Kithuzzz
• 38,010 points
200 views

1 answer to this question.

0 votes

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

answered Feb 10, 2023 by narikkadan
• 63,420 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 Mar 21, 2023 in Others by Kithuzzz
• 38,010 points
1,178 views
0 votes
1 answer

How to automatically assign a color to the maximum and minimum values in a set of selected cells in Excel?

See Conditional Formatting, which may be accessed ...READ MORE

answered Apr 7, 2023 in Others by Kithuzzz
• 38,010 points
306 views
–1 vote
0 answers
0 votes
2 answers
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
905 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
3,225 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
• 23,260 points
515 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,670 points
757 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
• 63,420 points
977 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
• 63,420 points
12,406 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