DEAR Excel Experts,
Your help with the below macro is greatly appreciated in order to save great time for my payroll processing.
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 macro, where I want each supervisor to split out on to his own sheet or file or tab ( whatever works) 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 file for each supervisor in which therefore, I can send emails to.
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