I am trying to delete dupliactes,
first I used delete duplicate row activity it is not doing anything
then i used delete duplicate range but since range is not fixed, so it is not working
then i tried to create macro and it is also taking a fixed range but range changes for every new sheet.
I am doing something like this