[Urgent] Updating of count of claims for each status for each employee

Hi, I had been trying to script in Uipath to get the count of the transaction for each employee in “Claim” tab which look like this:

and update the count of the claim status to the “Count” tab of the excel which will look like this after counting:

Here is the excel. qns.xlsx (12.0 KB)

I had tried for days and not getting anywhere. I’m sorry I’m not very good in understanding the VBA coding. Any help and guidance is appreciated. Thank you.

This is all you need to finish it in 1 minute