troubleshooting Question

Excel 2013 Find and copy duplicates to a new worksheet

Avatar of Nikola Vucica
Nikola Vucica asked on
Microsoft OfficeMicrosoft ExcelVBA
6 Comments1 Solution134 ViewsLast Modified:
Hello all,

Could an expert provide me with VBA to do similar like:

https://www.experts-exchange.com/questions/28390015/Excel-2010-Copy-Duplicates-to-a-new-worksheet.html

I have a spreadsheet that has an information in Sheet1 and Sheet2. The result must go into Sheet3.

Sheet1 have info in column A (number of rows will change). In this column every cell value is unique.
Sheet2 have info in columns A to F (number of rows will change). Column A may have duplicate values.


If the value of cell A1 of Sheet1 exists in column A of Sheet2, the program will copy that entire row of Sheet2
and paste it in the first free row in the Sheet3. The program must copy every row where he found the same value.


Many thanks in advance.
ASKER CERTIFIED SOLUTION
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros