Get the unique data based on multiple columns

[wulp2]

Hi,

I am responsible for licensing and need to report the delta per month; how many licenses were added last month and how many licenses were released last month. I have 80.000+ lines of data and through VBA I limit this list to the last 2 months. So as a result I have a dataset with only 2 dates, last months date en this months date.

I need to create 3 sheets, 1 sheet with licenses that were added this month, 1 sheet that contains no changes and 1 sheet where the software was removed from the machine so the license was removed.
See below screenshot. The left table is the data I have (simplified) and the other 3 tables represent the 3 sheets I need.

Before I start writing a humongous VBA project to get this done, Is there any other way I can do this more easily?

Thanks a lot in advance!

Wulp