find and move the duplicate values in another sheet

maximbebi

New Member
Joined
Feb 11, 2014
Messages
5
Hello,

I have a file with many values, distributed across multiple columns.

From sheet1 i want to find and move all the duplicate values in the sheet 2

and I need a macro,a code macro to work at the level of the sheets, Sheet1-Sheet2

I want to move cut/paste all values duplicates 2 times 3 times or how many times is found
from sheet1, in sheet2

in sheet 1 to remain single value, only the values themselves which didn't pair
I mean if a value is 2 times
to move the original value
but and double found
 
Last edited:

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,684
I suggest you do a search on 'Find duplicates' There are thousands upon thousands of threads which deal with this problem. You then only need to modify one of those solutions.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,950
Messages
5,525,822
Members
409,665
Latest member
Jessyi

This Week's Hot Topics

Top