Breaking News: Grepper is joining You.com. Read the official announcement!

copy data from one sheet to another in google sheets

Good Gnat answered on September 20, 2020 Popularity 8/10 Helpfulness 1/10

answer copy data from one sheet to another in google sheets

related google spreadsheet copy values from another sheet conditional

copy data from one sheet to another in google sheets

Comment

function sortAndCopyData() {
  var masterSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Master Sheet");
  var sheet11 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet11");

  // Get the range of data in the "Master Sheet"
  var dataRange = masterSheet.getRange(8, 1, masterSheet.getLastRow() - 7, masterSheet.getLastColumn());
  var values = dataRange.getValues();
  var formats = dataRange.getFontStyles();

  // Sort the data based on column 10 (index 9) in descending order
  values.sort(function(a, b) {
    return b[9] - a[9];
  });

  // Clear all data and formatting in "Sheet11" starting from row 8
  sheet11.getRange("A8:R").clear({ formatOnly: true });

  // Copy the top 50 rows of sorted data to "Sheet11" starting from row 8
  var top50Values = values.slice(0, 50);
  var targetRange = sheet11.getRange(8, 1, top50Values.length, top50Values[0].length);
  targetRange.setValues(top50Values);
  targetRange.setFontStyles(formats);

  // Revert the data in the "Master Sheet" to its original order
  dataRange.setValues(values);
  masterSheet.getRange("A8:R").sort({ column: 1, ascending: true });

  Logger.log("Data sorted and copied successfully.");
}

Popularity 8/10 Helpfulness 1/10 Language javascript

Source: chat.openai.com

Tags: copy google-sheets javascript

Link to this answer
Share Copy Link

Contributed on Jun 21 2023

Good Gnat

0 Answers Avg Quality 2/10

Closely Related Answers

google spreadsheet copy values from another sheet conditional

Comment

I see in the sample, sheet Form Responses, column C is Status. However, none of them are marked "Finished". If the rows were marked, the FILTER function could be use to display a list in the sheet Completed. Something like this
 
=FILTER('Form Responses 1'!A:Q, 'Form Responses 1'!C:C="Finished")
 
If you mark some of the rows "Finished", the results will display in the Completed sheet.

Popularity 9/10 Helpfulness 2/10 Language whatever

Source: support.google.com

Tags: conditional cond

Link to this answer
Share Copy Link

Contributed on Sep 20 2020

Lazy Climber

0 Answers Avg Quality 2/10

copy data from one sheet to another in google sheets

Contents

More Related Answers

copy data from one sheet to another in google sheets

Closely Related Answers

google spreadsheet copy values from another sheet conditional

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.