I have a spreadsheet in excel that includes a macro simple (less than 50 lines of code)
It mainly just moves stuff around
I have recreated the spreadsheet in google sheets [login to view URL]
but I can’t recreate the macro as I don’t know google apps script.
Is this something you could help with if so what would be the cost?
I include the vba code below
Thanks Neil
[login to view URL] = False
Dim lastrow As Integer
Dim user1 As Integer
Dim user2 As Integer
Dim total_users As Integer
total_users = [Totalusers].Value
user1 = 1
user2 = 2
' copy temp edit to scores
‘CurrentUserisnew is a named range
If [CurrentUserisNew].Value = "N" Then
Range("scores[temp edit]").Copy
Sheets("Scores").Select
Range("D2").Select
[login to view URL] Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End If
'copy new scores
If [TotalNewScores].Value > 0 Then
lastrow = [scoresnextblankrow].Value
Sheets("Variables").Range("E2:G1000").Copy
Sheets("Scores").Select
Range("B" & lastrow).Select
[login to view URL] Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
End If
'reset the formula
Sheets("FrontSheet").Select
[scoreformula].Copy
Range("F9").Select
Range(Selection, [login to view URL](xlDown)).Select
[login to view URL]
'clear corolation matrix
Sheets("CorlationMatrix").Select
Sheets("CorlationMatrix").Range("b2:G36000").ClearContents
Sheets("CorlationMatrix").Range("b2").Select
'paste user combo info into corolation matrix
Do While user1 <= total_users
Do While user2 <= total_users
Sheets("TempCorolationSheet").Range("c1").Value = user1
Sheets("TempCorolationSheet").Range("d1").Value = user2
Sheets("TempCorolationSheet").Range("C1:H1").Copy
Sheets("CorlationMatrix").Select
[login to view URL]
[login to view URL] Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
[login to view URL](1, 0).Range("A1").Select
user2 = user2 + 1
Loop
user1 = user1 + 1
user2 = user1 + 1
Loop
Sheets("FrontSheet").Select
[login to view URL] = True
[login to view URL] = False
[login to view URL] = True
Hello Neil,
I have seen the VBA code and i can convert i t into google script. I have 5 years experience in Excel VBA,Google script programming and completed 400+ projects. I never ask for payments in front. You can release the agreed milestones once the task is completed and you're happy with [login to view URL] my reviews to confirm my work quality
With Regards,
Sai