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

Help
1

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:
image

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

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.

2

This is all you need to finish it in 1 minute