PDA

View Full Version : Split Excel sheets to multiple Workbooks based on Criteria in Cell A1



mflank
03-09-2016, 08:23 AM
I have a file with many sheets, each sheet is relevant to a specific sales person. However, each salesperson always has 2 or more sheets. The sales person name is in cell A1 on every sheet. I am looking for a macro that would cycle through all the tabs in the worksheet and save a new file for each sales employee with their relevant sheet. The file name should be the sales employee's name

If possible, would also be great to automatically email each file to the relevant salesperson based on a list (or it can also always be in a cell, B1 for instance)

Many thanks