writing a "script"

[catgirl]

i want to do a:

foreach (i = 50,i++,i=1)
{
if column B value = "surname"
{
sum column C value

}
}

i have this but im sure it is completely wrong LOL

function myFunction() {

//var myDoc = SpreadsheetApp.getActiveSpreadsheet("Client Billing");
//var app = UiApp.createApplication().setTitle('Loots');

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("HS");
var lastRow = sheet.getLastRow();
var range = sheet.getRange(2,1,lastRow,7);
var values = range.getValues();
var data = range.getValues();
var newsheet = SpreadsheetApp.create("loots", 50, 3);
Logger.log(newsheet.getUrl());


for (i in data)
{
var row = data[i];
var date = row[0];
var client = row[1];
var activity = row[2];
var rate = row[6];
if (client = "loots")
{
row[410] = rate;
//newsheet[i,1] = date;
//newsheet[i,2] = activity;
//newsheet[i,3] = rate;
}
}
}
please help?

thanks

[Kyle123]

That's JavaScipt, are you making a 2013 app for office?

[catgirl]

nope i just want to write a little "program" that can do the foreach and the if within
ive never done it so dont know where to start

[Kyle123]

In that case you're going to need to give us more to go on:
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[catgirl]

here some sample data

sample data.JPG

say i want to loop through column B "Client"
if it contains the value for example "le roux"
write to a new sheet column A, B, C H

ex:

new sheet data.JPG

[Kyle123]

We need a workbook...

[catgirl]

i attached the workbook

[Marc L]

Paste this code to Sheet1 worksheet module :

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 
    With Target 
        If .Column = 2 And .Row > 1 And .Value > "" Then 
            Cancel = True 
            If Sheet2.UsedRange.Count < 4 Then Union([A1:C1], [H1]).Copy Sheet2.Cells(1) 
            Cells(2).Copy Sheet2.Cells(11):  .Copy Sheet2.[K2] 
            Cells(1).CurrentRegion.AdvancedFilter xlFilterCopy, Sheet2.[K1:K2], Sheet2.[A1:D1] 
 
            With Sheet2 
                .[K1:K2].Clear 
                With .Cells(1).CurrentRegion:  .WrapText = False:  .Columns.AutoFit:  End With 
                .Activate 
            End With 
        End If 
    End With 
End Sub  

Just double click on a client name …

Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

[catgirl]

nooo thats way to complicated, sorry

[Marc L]

When you will know Excel basics and VBA, you may understand that way maybe as easiest and fastest !