I don't have much experience with script editor, but I am trying to figure out a solution to my problem. Basically, I made a task list in Google Spreadsheets (let's call this GS1). This task list has multiple sheets. It has eight sheets and each sheet is identical in columns and rows. I am only interested in data from B3:I28.
At 8 PM each day, I'd like to take each sheet from GS1 starting from B3 to I28 and copy it to another Google Spreadsheets ("GS2") that also has eight sheets (exact same sheet names and sheet formats, etc). However, I want data from sheet 1 in GS1 to copy data to it's respective sheet 1 in GS2.
Data to copy from each sheet is in the range B3:I28 and paste it in the same location.
Is this possible?
I am not sure if pulling data or pushing data would be more likely and this will decide which GS will have the script.