Skip to main content
Web Applications

Return to Question

edited tags
Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297
Major grammar issues corrected. Removed thank you sign off. Clarified question title. Fixed indent error in code example
Source Link
Vidar S. Ramdal
Vidar S. Ramdal
  • 17.4k
  • 11
  • 71
  • 82

I have a sheet with IMPORTHTMLIMPORTHTML that I want to copy data from one column to a new column daily.

function saveData() {
      var spreadsheet = SpreadsheetApp.getActive();
      spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Daily ledger'), true);
      spreadsheet.getRange('x3:x96').activate();
      spreadsheet.getRange('N3:N96').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
}

This script works well, but I have to change 'x3:x96'x3:x96 every day (tomorrow I would have to change it manually to 'y3:y96'y3:y96 etc.), I also have to change the trigger date daily.

Is there a way to do it automatically? To have a script paste in a new column every day?

I know there is a way to do it in new row, but that is not what I am looking for.

I have a sheet with IMPORTHTML that I want to copy data from one column to a new column daily.

function saveData() {
      var spreadsheet = SpreadsheetApp.getActive();
      spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Daily ledger'), true);
      spreadsheet.getRange('x3:x96').activate();
      spreadsheet.getRange('N3:N96').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
}

This script works well, but I have to change 'x3:x96' every day (tomorrow I would have to change it manually to 'y3:y96' etc.), I also have to change the trigger date daily.

Is there a way to do it automatically? To have a script paste in a new column every day?

I know there is a way to do it in new row, but that is not what I am looking for.

I have a sheet with IMPORTHTML that I want to copy data from one column to a new column daily.

function saveData() {
      var spreadsheet = SpreadsheetApp.getActive();
      spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Daily ledger'), true);
      spreadsheet.getRange('x3:x96').activate();
      spreadsheet.getRange('N3:N96').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
}

This script works well, but I have to change x3:x96 every day (tomorrow I would have to change it manually to y3:y96 etc.), I also have to change the trigger date daily.

Is there a way to do it automatically? To have a script paste in a new column every day?

I know there is a way to do it in new row, but that is not what I am looking for.

Major grammar issues corrected. Removed thank you sign off. Clarified question title. Fixed indent error in code example
Source Link
edit approved Nov 8, 2018 at 12:01
Mark Shamy
edit approved Nov 8, 2018 at 12:01
Mark Shamy
  • 250
  • 1
  • 9

save Copy data into new column every dayin Google Sheets

iI have a sheet with IMPORTHTML, and i that I want to copy data from 1one column to a new every daycolumn daily.

   function saveData() {
      var spreadsheet = SpreadsheetApp.getActive();
      spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Daily ledger'), true);
      spreadsheet.getRange('x3:x96').activate();
      spreadsheet.getRange('N3:N96').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
}

thisThis script workworks well, but iI have to change x3:x96'x3:x96' every day (tommorow i willtomorrow I would have to change it manually to y3:y96'y3:y96' etc.), I also i have to change the trigger date daily.

Is there is a way to do it autoautomatically? That theTo have a script will paste in a new column every day?

iI know there is a way to do it in new row, but itsthat is not what iI am looking for.

Thank!

save data in new column every day

i have sheet with IMPORTHTML, and i want copy data from 1 column to new every day.

   function saveData() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Daily ledger'), true);
  spreadsheet.getRange('x3:x96').activate();
  spreadsheet.getRange('N3:N96').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
}

this script work well, but i have to change x3:x96 every day (tommorow i will change manually to y3:y96 etc.), also i have to change the trigger date daily.

there is a way to do it auto? That the script will paste in a new column every day?

i know there is a way to do it in new row, but its not what i am looking for.

Thank!

Copy data to new column in Google Sheets

I have a sheet with IMPORTHTML that I want to copy data from one column to a new column daily.

function saveData() {
      var spreadsheet = SpreadsheetApp.getActive();
      spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Daily ledger'), true);
      spreadsheet.getRange('x3:x96').activate();
      spreadsheet.getRange('N3:N96').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false);
}

This script works well, but I have to change 'x3:x96' every day (tomorrow I would have to change it manually to 'y3:y96' etc.), I also have to change the trigger date daily.

Is there a way to do it automatically? To have a script paste in a new column every day?

I know there is a way to do it in new row, but that is not what I am looking for.

added 169 characters in body
Source Link
akiva
akiva
  • 103
  • 2
Source Link
akiva
akiva
  • 103
  • 2