Modify code that splits data from master worksheet to multiple workbooks

[Bluebll81]

Hi,

I found some useful vba code online to copy specific data to a new workbook based on the column chosen and was able to modify the code to meet my requirements.

I would like to modify the code some more in order to copy the following worksheets to each of the new workbooks before they are saved to the folder location:

Worksheet “Supplier Name” to be copied to the beginning of each new workbook generated by the criteria chosen in the column
Worksheet “Activity Codes” to be copied to the end of each new workbook generated by the criteria chosen in the column

Ideally I would also like to copy the chosen criteria to different worksheets based on school and scope, currently all data is copied to a new workbook named sheet1 for each school regardless of whether it is in or out of scope.

My new workbooks would then have the following – A workbook saved for each school

Worksheets:

Supplier List(copied from master file)
In – criteria copied from chosen column (school) but ideally only those that are in scope
Out - criteria copied from chosen column (school) but ideally only those that are out of scope
Activity Codes (Copied from master file)

I have attached a sample file for reference.

Thank you in advance.