I found this code:

HTML Code: 
I want to run this from a different worksheet, how can i change this code so it will run on a particular worksheet?

Further i would like to know how i can rows which are duplicates can clear, not delete, so only 1 row will remain.

Guido