Well.... this "final" request requires some clarification.

What determines a record to be a duplicate? Every cell of the row being the same, or just certain columns?
Do you or are you able to sort the data so the duplicates are together?
Which of the duplicates should be moved to the dupesheet?
How, when, why would you know this macro should run?

And after that, what's causing the duplicates and can they be prevented?