Macro to remove duplicates values and keep unique values bases on multiple criteria

I have a table that I copy and paste employee data into, then manually enter start and end times for a daily work schedule. I would like to have a macro that removes duplicates and keeps certain unique values. Essentially, I'll have a table with a list of names and shift times, then I'll generate a new list. Some of the names and shifts will duplicate, while others drop off, and new ones are created.

It's kind of hard to explain so I've attached an example spreadsheet with before and after tabs.

Any help is greatly appreciated.

Try this.

Please Login or Register  to view this content.