Check two lists on separate worksheets and copy only unique values

Hello,

I have a macro that works for the task at hand, but takes a very long time to complete.

I am comparing project numbers (roughly 8 to 10 each day) for every single day of the week from January 1, 2017 through September 30, 2017. The code is designed to review a detailed list which has duplicates, due to projects needing to be entered on different days to account for the time spent working on the project each day, and FilterCopy only the unique values so the project number is only listed one time on a summary report. The summary report takes all the details from the individual entries and aggregates them into a report where the user can clearly see how much time has been spent on the project each day, month and in total.

I ran the macro this morning, for data from January 1, 2017 through September 30, 2017 and it took 10-15 minutes just to complete the comparison and copy unique values. Does anyone have suggestions on how to improve the code, or a more resource efficient suggestion?

Please Login or Register  to view this content.

Thanks for the offers! I will work on a blinded data set that I can upload for others to review. Because of the nature of our business, I cannot disclose client names or project details (which are included in my file).

MarvinP - I will also take a look at the sample file you uploaded to see if that will work to solve my problem.

I have attached the file for review. The goal is to take the details on the "NS Detail" tab and summarize them by project onto the "Time Report" tab. To run the macro, Press Ctrl+Shift+L in cell A4 on the Time Report. It will take several minutes to run so don't do it unless you have some time on your hands to wait it out.

Thanks!

That's what I needed! Thanks, again.