Count number of users active each mont

[Wandem]

Hello,

I have a table with a list of users active in a system. There are the date that user was registered and the date that user was disabled. If the user was not disabled, than it`s active. I need a table summarizing number of user, per company, per month. How do I do this using VBA?

Thanks for any help.

I have data like this

ID user	User active	Register date	Date of exclusion	Company
10	n	01052020	10062020	Beer
11	y	01032020		Cat
12	y	01052020		Cat
13	y	01042020		Beer
14	n	01062020	01072020	Beer

Table generated in 07152020

I would like to have a table like this

Company	Month	Number of users
Beer	032020	0
Beer	042020	1
Beer	052020	2
Beer	062020	3
Beer	072020	2
Cat	032020	1
Cat	042020	1
Cat	052020	2
Cat	062020	2
Cat	072020	2