PDA

View Full Version : Select duplicates rows in a new sheet



nedy_03
10-17-2007, 09:02 PM
Hello,

Is there a code that can select all the duplicates rows from an xls sheet and put them in a separate sheet?? ... But all the duplicates rows, what I'm trying to say is that if in, let's say, sheet1 I have a row 3 times it takes it and puts in sheet2 3 times.

Can somebody help me with that? ...

thx,
Nedy

stanleydgrom
10-18-2007, 05:51 PM
Nedy,

If there are three duplicate rows in sheet1, you want to copy all three rows into sheet2, or you want to move the three rows in sheet1 to sheet2?

Please post your workbook.

Have a great day,
Stan