Could anyone help with a utility or method for automatically splitting an
Excel file into multiple files on each change in a subtotal value? And later
for reassembling the files into one?

I'd very much appreciate help with this, as splitting a master file into 75
individual teacher files has gotten tedious...

Thanks!