Copy a range and paste only rows with values into another sheet at the next blank row?

-1

I'm trying to build off of what was solved here:

How do you copy a range and paste only rows with values into another sheet?

I want to do this with a bigger range (O1:X500 on the sheet named "RGDR") copying only the rows with values in them and then paste them in the new sheet ("ACTUALFUNC") in the next blank row.

The sheet is here: https://docs.google.com/spreadsheets/d/1vvXQxBGffwBAjbXKqx4N-ZFcX40wuV7gg9flb6STWtA/edit?usp=sharing

Below is the code I already tried. It only brings over the first column of data.

function copyRangeNoEmpties(){

  var ss=SpreadsheetApp.getActive();

  var sh=ss.getSheetByName('RGDR');

  var copyToSheet=ss.getSheetByName('ACTUALFUNC');

  var copyFromRange=sh.getRange('O1:X500');

  var vA=copyFromRange.getValues();

  var oA=;

  for(var i=0;i<vA.length;i++)

  {

    if(vA[i][0])

    {

      oA.push([vA[i][0]]);

    }

  }

  var copyToRange=copyToSheet.getRange(1,1,oA.length,1);

  copyToRange.setValues(oA);

}

Looking to build a ongoing list of results by running this once daily. Any help or input will be greatly appreciated.

asked Jan 2 at 21:59

D. Minor

Your only putting the first column of data into oA . Instead try oA.push(vA[i])

– Cooper
Jan 2 at 22:19

Also change var copyToRange=copyToSheet.getRange(1,1,oA.length,1); to var copyToRange=copyToSheet.getRange(1,1,oA.length,copyFromRange.getWidth());

– Cooper
Jan 2 at 22:23

add a comment |

-1

I'm trying to build off of what was solved here:

How do you copy a range and paste only rows with values into another sheet?

I want to do this with a bigger range (O1:X500 on the sheet named "RGDR") copying only the rows with values in them and then paste them in the new sheet ("ACTUALFUNC") in the next blank row.

The sheet is here: https://docs.google.com/spreadsheets/d/1vvXQxBGffwBAjbXKqx4N-ZFcX40wuV7gg9flb6STWtA/edit?usp=sharing

Below is the code I already tried. It only brings over the first column of data.

function copyRangeNoEmpties(){

  var ss=SpreadsheetApp.getActive();

  var sh=ss.getSheetByName('RGDR');

  var copyToSheet=ss.getSheetByName('ACTUALFUNC');

  var copyFromRange=sh.getRange('O1:X500');

  var vA=copyFromRange.getValues();

  var oA=;

  for(var i=0;i<vA.length;i++)

  {

    if(vA[i][0])

    {

      oA.push([vA[i][0]]);

    }

  }

  var copyToRange=copyToSheet.getRange(1,1,oA.length,1);

  copyToRange.setValues(oA);

}

Looking to build a ongoing list of results by running this once daily. Any help or input will be greatly appreciated.

asked Jan 2 at 21:59

D. Minor

Your only putting the first column of data into oA . Instead try oA.push(vA[i])

– Cooper
Jan 2 at 22:19

Also change var copyToRange=copyToSheet.getRange(1,1,oA.length,1); to var copyToRange=copyToSheet.getRange(1,1,oA.length,copyFromRange.getWidth());

– Cooper
Jan 2 at 22:23

add a comment |

-1

I'm trying to build off of what was solved here:

How do you copy a range and paste only rows with values into another sheet?

I want to do this with a bigger range (O1:X500 on the sheet named "RGDR") copying only the rows with values in them and then paste them in the new sheet ("ACTUALFUNC") in the next blank row.

The sheet is here: https://docs.google.com/spreadsheets/d/1vvXQxBGffwBAjbXKqx4N-ZFcX40wuV7gg9flb6STWtA/edit?usp=sharing

Below is the code I already tried. It only brings over the first column of data.

function copyRangeNoEmpties(){

  var ss=SpreadsheetApp.getActive();

  var sh=ss.getSheetByName('RGDR');

  var copyToSheet=ss.getSheetByName('ACTUALFUNC');

  var copyFromRange=sh.getRange('O1:X500');

  var vA=copyFromRange.getValues();

  var oA=;

  for(var i=0;i<vA.length;i++)

  {

    if(vA[i][0])

    {

      oA.push([vA[i][0]]);

    }

  }

  var copyToRange=copyToSheet.getRange(1,1,oA.length,1);

  copyToRange.setValues(oA);

}

Looking to build a ongoing list of results by running this once daily. Any help or input will be greatly appreciated.

asked Jan 2 at 21:59

D. Minor

I'm trying to build off of what was solved here:

How do you copy a range and paste only rows with values into another sheet?

I want to do this with a bigger range (O1:X500 on the sheet named "RGDR") copying only the rows with values in them and then paste them in the new sheet ("ACTUALFUNC") in the next blank row.

The sheet is here: https://docs.google.com/spreadsheets/d/1vvXQxBGffwBAjbXKqx4N-ZFcX40wuV7gg9flb6STWtA/edit?usp=sharing

Below is the code I already tried. It only brings over the first column of data.

function copyRangeNoEmpties(){

  var ss=SpreadsheetApp.getActive();

  var sh=ss.getSheetByName('RGDR');

  var copyToSheet=ss.getSheetByName('ACTUALFUNC');

  var copyFromRange=sh.getRange('O1:X500');

  var vA=copyFromRange.getValues();

  var oA=;

  for(var i=0;i<vA.length;i++)

  {

    if(vA[i][0])

    {

      oA.push([vA[i][0]]);

    }

  }

  var copyToRange=copyToSheet.getRange(1,1,oA.length,1);

  copyToRange.setValues(oA);

}

Looking to build a ongoing list of results by running this once daily. Any help or input will be greatly appreciated.

google-apps-script

asked Jan 2 at 21:59

D. Minor

asked Jan 2 at 21:59

D. Minor

asked Jan 2 at 21:59

D. Minor

asked Jan 2 at 21:59

D. Minor

asked Jan 2 at 21:59

D. Minor

Your only putting the first column of data into oA . Instead try oA.push(vA[i])

– Cooper
Jan 2 at 22:19

Also change var copyToRange=copyToSheet.getRange(1,1,oA.length,1); to var copyToRange=copyToSheet.getRange(1,1,oA.length,copyFromRange.getWidth());

– Cooper
Jan 2 at 22:23

add a comment |

Your only putting the first column of data into oA . Instead try oA.push(vA[i])

– Cooper
Jan 2 at 22:19

Also change var copyToRange=copyToSheet.getRange(1,1,oA.length,1); to var copyToRange=copyToSheet.getRange(1,1,oA.length,copyFromRange.getWidth());

– Cooper
Jan 2 at 22:23

Your only putting the first column of data into oA . Instead try oA.push(vA[i])

– Cooper
Jan 2 at 22:19

Also change var copyToRange=copyToSheet.getRange(1,1,oA.length,1); to var copyToRange=copyToSheet.getRange(1,1,oA.length,copyFromRange.getWidth());

– Cooper
Jan 2 at 22:23

add a comment |

1 Answer
1

active

oldest

votes

This will append your data to the next row on your destination sheet.

function copyRangeNoEmpties(){

  var ss=SpreadsheetApp.getActive();

  var sh=ss.getSheetByName('RGDR');

  var des=ss.getSheetByName('ACTUALFUNC');

  var src=sh.getRange('O1:X500');

  var vA=src.getValues();

  for(var i=0;i<vA.length;i++) {

    if(vA[i].join("")) {

      des.appendRow(vA[i]);

    }

  }

}

answered Jan 2 at 23:00

Cooper

8,2042829

This works great! Cooper you are awesome! Many thanks!

– D. Minor
Jan 2 at 23:07

add a comment |

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54013725%2fcopy-a-range-and-paste-only-rows-with-values-into-another-sheet-at-the-next-blan%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

This will append your data to the next row on your destination sheet.

function copyRangeNoEmpties(){

  var ss=SpreadsheetApp.getActive();

  var sh=ss.getSheetByName('RGDR');

  var des=ss.getSheetByName('ACTUALFUNC');

  var src=sh.getRange('O1:X500');

  var vA=src.getValues();

  for(var i=0;i<vA.length;i++) {

    if(vA[i].join("")) {

      des.appendRow(vA[i]);

    }

  }

}

answered Jan 2 at 23:00

Cooper

8,2042829

This works great! Cooper you are awesome! Many thanks!

– D. Minor
Jan 2 at 23:07

add a comment |

This will append your data to the next row on your destination sheet.

function copyRangeNoEmpties(){

  var ss=SpreadsheetApp.getActive();

  var sh=ss.getSheetByName('RGDR');

  var des=ss.getSheetByName('ACTUALFUNC');

  var src=sh.getRange('O1:X500');

  var vA=src.getValues();

  for(var i=0;i<vA.length;i++) {

    if(vA[i].join("")) {

      des.appendRow(vA[i]);

    }

  }

}

answered Jan 2 at 23:00

Cooper

8,2042829

This works great! Cooper you are awesome! Many thanks!

– D. Minor
Jan 2 at 23:07

add a comment |

This will append your data to the next row on your destination sheet.

function copyRangeNoEmpties(){

  var ss=SpreadsheetApp.getActive();

  var sh=ss.getSheetByName('RGDR');

  var des=ss.getSheetByName('ACTUALFUNC');

  var src=sh.getRange('O1:X500');

  var vA=src.getValues();

  for(var i=0;i<vA.length;i++) {

    if(vA[i].join("")) {

      des.appendRow(vA[i]);

    }

  }

}

answered Jan 2 at 23:00

Cooper

8,2042829

This will append your data to the next row on your destination sheet.

function copyRangeNoEmpties(){

  var ss=SpreadsheetApp.getActive();

  var sh=ss.getSheetByName('RGDR');

  var des=ss.getSheetByName('ACTUALFUNC');

  var src=sh.getRange('O1:X500');

  var vA=src.getValues();

  for(var i=0;i<vA.length;i++) {

    if(vA[i].join("")) {

      des.appendRow(vA[i]);

    }

  }

}

answered Jan 2 at 23:00

Cooper

8,2042829

answered Jan 2 at 23:00

Cooper

8,2042829

answered Jan 2 at 23:00

Cooper

8,2042829

answered Jan 2 at 23:00

Cooper

8,2042829

This works great! Cooper you are awesome! Many thanks!

– D. Minor
Jan 2 at 23:07

add a comment |

This works great! Cooper you are awesome! Many thanks!

– D. Minor
Jan 2 at 23:07

This works great! Cooper you are awesome! Many thanks!

– D. Minor
Jan 2 at 23:07

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu