Copy-paste with one eye on duplicates

[imoizr]

Hi Guys,

Here is my challenge:

Scenario:
I have a workbook containing about 150 worksheets. Each worksheet contains a single column which has the email addresses of my subscribers. Each worksheet contains between 2,000-30,000 rows. The reason for the many worksheets is the email addresses are obtained from different sources (hence possibility of duplicates)

What I have done:
I have copied all the email addresses from each worksheet into a master worksheet and run the “remove duplicates” command. This is pretty straightforward although a little time consuming copy-paste 150 worksheets into the master. If there is a simpler way, I will take it

What I want to accomplish
Now coming to the more challenging part. This workbook will continuously be updated with more worksheets with email addresses. What I want to is; before copying the new email addresses into the master worksheet, I want to ensure that there are not duplicate addresses (otherwise the subscriber will get more than one email)

Thank you and any guidance will be greatly appreciated

[Kaper]

You can euther copy new data under previously collected and run Remove Duplicates again, or you can add a column to your data to be added with formula

Please Login or Register  to view this content.

copy this formula down and autofilter only FALSE values
then copy visible data to your master sheet