im working on a process and completed the automation of around 50% of it, and I’m still struggling with the other 50
i’ve used Pivot Table to analyze excel data and then IF statement to to filter the selected criteria
the pivottable looks like something similar to the below:
From the above table, i want to send signal email to manager and attaching excel with list of employee names and the issue they have in their data:
- Status NOT Equal to Approved.
- Date is beyond 2021.
- Value NOT Equal to 100.
The way i did it so far is that the robot will send individual email for every record that has an issue, but the way i want it is to generate another excel for every manager and list the employees in it and write the issue in his record in another column, e.g. in above image, manager 1 will recive an email with list of 2 employees, 1 is the value not equal to 100 and the other one date beyond 2021 & value not equal to 100.
i hope it’s clear and someone can help much appreciated.