find and move the duplicate values in another sheet

maxi

New member
Joined
Feb 19, 2014
Messages
1
Reaction score
0
Points
0
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 the results to be made in columns A and B

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

Thank you
 

Attachments

  • maxim.xlsx
    11.3 KB · Views: 18
Back
Top