I'm seeing solutions regarding splitting an Excel file into separate
worksheets (FL0009), but is it possible to separate the file into completely
separate files? I have a master file that needs to be split into separate
files which will be password protected and emailed. One of the columns
contains a name which is the criteria for splitting the file.