find and move the duplicate values in another sheet

[maxi]

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

[p45cal]

For others: cross-posted wholesale:

http://www.excelguru.ca/forums/showt...-another-sheet
http://www.mrexcel.com/forum/excel-q...her-sheet.html
http://windowssecrets.com/forums/sho...381#post941381
http://stackoverflow.com/questions/2...-another-sheet
http://www.excelforum.com/excel-prog...her-sheet.html
http://www.marshut.com/iqkqzr/find-a...her-sheet.html
http://buradabuldum.blogspot.co.uk/2...duplicate.html
http://chandoo.org/forum/threads/fin...r-sheet.14950/

For maxi, some light reading:
http://www.excelguru.ca/content.php?...-cross-posters