Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
added 20 characters in body; edited title
Source Link
pnuts
pnuts
  • 17.8k
  • 5
  • 54
  • 103

How to pull data from multiple sheets in Google SpreadsheetSpreadsheets 1 and transfer to multiple sheets in Google SpreadSheetSpreadsheets 2?

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 spreadsheetsGoogle Spreadsheets (let's call this GS1). This task list has multiple sheets. It has 8eight 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 spreadsheetGoogle Spreadsheets ("GS2") that also has 8eight 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.

How to pull data from multiple sheets in Google Spreadsheet 1 and transfer to multiple sheets in Google SpreadSheet 2?

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 8 sheets and each sheet is identical in columns & 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 spreadsheet ("GS2") that also has 8 sheets(exact same sheet names & 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 & 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.

How to pull data from multiple sheets in Google Spreadsheets 1 and transfer to multiple sheets in Google Spreadsheets 2?

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.

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
edited tags; edited tags
Link
ale
ale
  • 52.9k
  • 42
  • 165
  • 314
Source Link
Mbagz
Mbagz
  • 11
  • 2

How to pull data from multiple sheets in Google Spreadsheet 1 and transfer to multiple sheets in Google SpreadSheet 2?

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 8 sheets and each sheet is identical in columns & 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 spreadsheet ("GS2") that also has 8 sheets(exact same sheet names & 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 & 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.