Hello,

Can anyone please let me know how to use Remove duplicates command on multiple sheets? I do not want to compare data within sheets. I just want the basic Data-->Remove Duplicates option-->Select all columns and run. But I need this to be run on all the sheets in the excel. It is taking lot of time to go sheet by sheet. Any easier way to do this? Thank you in advance.