How to check & filter duplicates in multi worksheets?

[vixz16]

I have an excel sheet with more than 45 work sheets in it. Each worksheet has around 200 names, phone nos & addresses.

Everyday I find more people and add a new worksheet to the same excel (I add them date wise).

Now my biggest problem is that I need to check that the names, phone nos & addresses I have taken out today are not present in the other 45 worksheets.

I can remove the duplicates from the same worksheet, but How do I check and remove the today's from the other 45 worksheets so there are no duplicates.

I can manually check each and every data that I add today, but it takes too much time as there are more than 200 entries daily. I would like to use a filter or some automated method.

Please help!

[:) Sixthsense :)]

You have two options in this case.

1) Keep all data in single sheet instead of keeping in 45 sheets.
2) You have to go for VBA solution

[vixz16]

That cannot be done, I have to report back to my client with the date wise separated data only.. I need to send them using some advanced filter feature

[:) Sixthsense :)]

Ok… If possible just add some dummy data in a workbook to cover the logic and attach a sample file with expected output for better understanding.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).