Evaluating bids

Planilha automatizada Google Sheets

Published on the November 23, 2019 in IT & Programming

About this project

Open

Eu tenho uma planilha feita por mim em código VBA para o excel. Eu preciso transportar a mesma funcionalidade para o Google Planilhas. As funções que preciso reproduzir são Hiderow condionalmente, HideCollumn condionalmente e Hiperlink.
O código principal é esse.

Sub DM_Clique()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
ElapsedTime = Timer
Worksheets("Dados").Range("A:B").EntireColumn.Hidden = False
Worksheets("Dados").Range("C:AO").EntireColumn.Hidden = True
Worksheets("Dados").Range("ap:au").EntireColumn.Hidden = False
Worksheets("Dados").Range("av:xfd").EntireColumn.Hidden = True
Worksheets("Dados").Range("A3:IV4000").EntireRow.Hidden = True
For a = 3 To 4000
    If Worksheets("Dados").Cells(a, 16).Value = "V" Then
    Worksheets("Dados").Rows(a).Hidden = False
    End If
Debug.Print Timer - ElapsedTime
Next
ThisWorkbook.Sheets("Dados").Activate
ThisWorkbook.Sheets("Dados").Range("a2").Select
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub

Category IT & Programming
Subcategory Web development
What is the scope of the project? Small change or bug
Is this a project or a position? Project
I currently have I have specifications
Required availability As needed
API Integrations Cloud Storage (Dropbox, Google Drive, etc.)
Roles needed Developer

Delivery term: Not specified

Skills needed

JavaScript MySQL PHP

Want to start working on this project?

Log into your Workana account or Register today. Boost your freelance work!

Other projects posted by G. R.