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
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
Bookmarks