google spreadsheet - copy cell range and paste below -


i have google sheet names "queue tracker" , in tab named "compiled dispositions". auto select , copy multiple ranges (which contain formulas) , paste "n" number of rows below. n can 100 or 1000 or 3000.

the ranges select , copy : b3:k3, m3:v3, x3:ag3, ai3:ar3, at3:bc3, be3:bo3, bq3:bz3, cb3:ch3, ck3:cp3, cs3:cx3, da3:df3

i don't believe it's possible access multiple range selections google apps script. using active selections won't work. treats selected ranges 1 range in null out unwanted columns. not planning on copying areas populated dated. haven't tested can use starting point. give chance know our script editor , debugger.

function copyyourrowtorange(row, numrows) {   var leaveblank=['0','11','22','33','44','55','67','78','86','87','94','95','102','103'];   var ss=spreadsheetapp.getactive();   var sht=ss.getactivesheet();   var rng=sht.getrange('b3:df3');   var rnga=rng.getformulas();   for(var i=0;i<leaveblank;i++)   {     rnga[0][leaveblank[i]]='';   }   var str='b' + row + ':df' + number(row + numrows);   var destr=sht.getrange(str);   var desta=destr.getvalues();   for(var i=0;i<desta.length;i++)   {     desta[i]=rnga[0];   } } 

Comments

Popular posts from this blog

html - How to set bootstrap input responsive width? -

javascript - Highchart x and y axes data from json -

javascript - Get js console.log as python variable in QWebView pyqt -