Split output into multiple Excel files to different folders

[YeahMan]

Hi Community,

I'm trying to split my output into multiple Excel and save to multiple different directories/folders based on fields in my data. My data looks like:

I would like each Program to be its own Excel file AND I would like to save the output to a folder that matches the School. So all the data related to 'Acting for Film and Television - P0198' would be written to

...\Schools\Media\Programs\Acting for Film and Television - P0198.xlsx.

Similarly, 'Culinary Management - P0435' data would be saved to ...\Schools\Food & Wine Sciences\Programs\Culinary Management - P0435.xlsx.

The folders for the Schools already exist; I just need to separate the data, give each Excel workbook the appropriate name and dump it in the right place by matching on the School. I've looked at a bunch of the posted solutions, but I am not finding anything that combines the 2 tasks. BTW there are 137 programs so using filters would be a bit daunting.

Thanks,

--sue

[YeahMan]

Thanks, but that isn't working either. I'm going to post this particular problem to the community. I don't seem to be able to get the output to the different directories.