Button to Remove duplicate and pasting the deleted row in another sheet

Hi!

I am looking for a button on a excel sheet to remove duplicate rows in a excel sheet.In me sheet there are 10 columns and data can be duplicated in 4 columns.So the function should check duplicate on 1 to 4 columns.And also it should give a message box that which row has to be deleted out of 2 or 3 same records.The deleted row should get pasted into another excel sheet.

I tried to look for this kind of solution and I am unable to get it.

Thanks in advance.

Loving

Hi, Loving,

Hmm... Though I am a beginner at VBA, I do have some ideas of how the logic might go to solve that problem, but I'm a little unclear as to what counts as a duplicate row. If row 6 (for instance), were a duplicate of row 2, does that mean that the data in the 4 columns in row 2 is exactly identical to the data in the 4 columns in row 6? Or does that just mean that the data in one of the 4 columns in row 2 is identical to the data in one of the 4 columns in row 6? And if the latter is the case, does it necessarily have to be the same column?

Susie