Populating a table with number of occurences of a particular text

[antzint]

Hi,
I have a problem here with my excel sheet which I had attached with this post. I have a table from which I wanted to calculate the number of occurences of a text and paste it in another predefined table. Is this possible?

In the example in the attachment, I had manually counted and entered the values in the table to create the chart.

Question:
Is it possible to create a macro/program so that the table automatically counts the number of 'notifications' for each 'Drawing cause type' in the column E and enters it in the table ? --> (Please refer to the attachment)

Kind Regards,
Antz

Calculating the Number of occurences_Example.xlsx

[AB33]

This code is not automatic and needs to run it

Please Login or Register  to view this content.

[antzint]

Hi AB33,
Thank you for the code. But I have another doubt.
When I run the code using a command button, it actually populates the table. But if I still want all of the types under the "Drawing Cause type" with "No. of Notification" to be 0 (if there isn't any occurences) what line of code should I use?
I have attached the file which I am working on for your reference.

Calculating the Number of occurences_Example.xlsm

Kind Regards,
Antz