New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Need A code to split records into seperate workbooks

Macros, VBA, Excel Automation, etc.

Need A code to split records into seperate workbooks

Postby TonyC » Thu Aug 11, 2016 10:24 am

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
  • 0

You do not have the required permissions to view the files attached to this post.
TonyC
Rookie
 
Posts: 13
Joined: Dec 17, 2015
Reputation: 0
Excel Version: 2010

Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 2 guests

cron