I know I m a pain but I have spent the last few hours trying to covert the below code over to google script. with very little luck.
Can any one help
the code I want coverting
Sub WrapCols()
Dim rng As Range
Dim i As Long, j As Long
i = 1
j = 2
For Each rng In Range("A1:A600")
Cells(i, j) = rng
If j > 6 Then
j = 2
i = i + 1
Else
j = j + 1
End If
Next rng
End Sub
and where i am stuck
function CopyRow() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var rawSheet = ss.getSheetByName("RAW");
var dataSheet = ss.getSheetByName("DATA");
dataSheet.getRange("A5:C1000").clear();
var partNumber = dataSheet.getRange(1,1).getValue();
var lastRow = rawSheet.getLastRow() + 1;
for(var j = 2; j < lastRow; j++)
for(var k = 2; K > 6; k++)
{
if(rawSheet.getRange(j,1).getValue())
{
var nextRow = dataSheet.getLastRow() +1;
var nextColumn = dataSheet.getLastColumn() +1
var getCopyRange = rawSheet.getRange('A' + j);
getCopyRange.copyTo(dataSheet.getRange(nextRow, 1));
}
}
}
New contributor
Steve Chambers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2