title: Split data into different Google Sheets files
body: <p>I have this one main file in Google Sheets. Now, I need to split this data such that its gets sent to " X " number of new files ( not a separate sheet). The data that is being sent is a subset of the data from the main file.
  Is it possible to create these new workbooks and populate them with this subset data?</p>
  
  <p>I tried creating new sheets, but the script is only working on creating it within the currently active sheet, and I cant find anything that is copying a range to a new sheet.</p>