Terminé

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

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

Compétences : Visual Basic pour les apps

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) United Kingdom

Nº du projet : #18186737

Décerné à:

SBITServices

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 Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% GBP en 1 jour
(17 Commentaires)
4.3