DEAR Excel Experts,
I am trying send out payroll reports for a bunch of supervisors/managers
The attached sheet has a bunch of employees whom are missing certain criteria’s in which I need to send an email to each employee supervisor certain notifications.
Therefore, the major player in this sheet is going to be the supervisor name (which I highlighted in red).
I need a code, where I want each supervisor to split out on to his own workbook with his or her corresponding data fields such as –Supv ID, Empl ID, Name, Action, Job code, etc.. (All the fields highlighted in green). This way I will have a workbook for each supervisor in which i can save to a predefined location and then send an email out .
So for instance, some supervisors like (John do) will only pull one record, but some supervisors like (John shee) will pull two records and so on. Just as if you would filter under each supervisor.
Thank you all so much in advance
Tony