find and move the duplicate values in another sheet

[maximbebi]

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

 

[sijpie]

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.