Google Sheets - Auto-Generate sheets named with a cell value in a row and populated with remaining row data -
i'm trying use google sheets script editor create set of sheets form create individual sheets named after value of each cell in column "b" , populated data in rows 1 , x, x value of row each sheet.
what have far is:
function makesheets() { var ss = spreadsheetapp.getactive(); var sheets = ss.getsheets(); sheets[0].getrange('b2:b100') .getvalues() .foreach(function (el, i) { if (el[0] && !ss.getsheetbyname(el[0])) ss.insertsheet(el[0], sheets.length +i) }); }
this create new sheets same header rows (row 1) 1 new sheets. don't understand x want create.
function makesheets() { var ss = spreadsheetapp.getactive(); var sheets = ss.getsheets(); var r1=sheets[0].getrange('1:1').getvalues() sheets[0].getrange('b2:b100') .getvalues() .foreach(function (el, i) { if (el[0] && !ss.getsheetbyname(el[0])) ss.insertsheet(el[0], sheets.length +i).getrange('1:1').setvalues(r1); }); }
Comments
Post a Comment