vba macro to google apps script

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



[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



Range("B" & lastrow).Select

[login to view URL] Paste:=xlPasteValuesAndNumberFormats, Operation:= _

xlNone, SkipBlanks:=False, Transpose:=False

End If

'reset the formula




Range(Selection, [login to view URL](xlDown)).Select

[login to view URL]

'clear corolation matrix




'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



[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


user1 = user1 + 1

user2 = user1 + 1



[login to view URL] = True

[login to view URL] = False

[login to view URL] = True

Competenze: Visual Basic per App

Vedere di più: google sheets macros, excel macros in google sheets, spreadsheet macros, google apps script vs vba, vba in google sheets, convert excel macro to google spreadsheet, google sheets record macro, convert excel vba to google sheets, google apps script email verification, google apps script smtp, email validation google apps script, google apps script validation, google apps script api, google apps script attachments forward, google apps script for sheets, google apps script, i am looking for someone to write a google apps script in google sheets, make repairs to google apps script, outsource programming google apps script, google apps script tutorial

Sul datore di lavoro:
( 0 valutazioni ) United Kingdom

ID Progetto: #18186737

Assegnato a:


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 fr Più

£15 GBP in 1 giorno
(17 valutazioni)