Hello everyone,
Got another brain teaser, I'm not even sure really where to begin with this one.
Step 1: I have a spreadsheet, I would like to break it up into several different spreadsheets based on the content of the first column (which indicates which tool the data belongs to) Currently I am manually selecting the individual rows with data filter and using the subset function to create a new spreadsheet containing that data. If possible, I would like a script to do this.
Step 2: I recently discovered that as long as the file names are the same I can use the project file I've already made to generate a new project with the data, so it is only important that the file names be generated the same each time (simple as the file names are the tool names in the column)
Step 3: success!
I don't know how to start this code, when I try to create a session script it does not really generate anything useful... If I can get the script just to split the data by tool that would be more than enough, saving them automatically would simply be icing. Thanks in advance!
