Deleting Duplicates from a range spread over 5 sheets

J

jimmy

I have a script that will delete duplicate entries for a
user selected column. My problem is that the data set i
am currently working on is HUGE, spread across 5 sheets,
and duplicates can occur on any of the 5 sheets. My
question is how to modify my script so that it checks each
sheet instead of only one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match and delete rows on two different sheets from reference numbers 4
Duplication 2
Highlighting duplicates across many sheets 3
Data Validation, Identify Duplicates and Limit imput 11
delete duplicates 0
Deleting/Clearing duplicate range of cells 8
Merging duplicate entries in Excel or deleting the duplicates (Exc 1
Cleaning up spread sheets 1

Top