Write basic script in google sheets for exporting to a new worksheet

$10-30 AUD

Imefungwa

Imechapishwa

almost 7 years ago

$10-30 AUD

Kulipwa wakati wa kufikishwa

We require a simple Google Sheets script to be written. We have a copy of the VBR macro we used to use in Excel and simply require the same functionality in Google Sheets. Please see origonal Excel script below: Sub NewPortfolio_Button1_Click() Dim i As Integer [login to view URL] = False Sheets("New Portfolio").Copy [login to view URL] [login to view URL] [login to view URL] Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Columns("S:AZ").Select [login to view URL] Shift:=xlToLeft [login to view URL](Array("Button 1")).Select [login to view URL] Cells(1, 1).Select For i = 50 To 200 If Cells(i, 1) = "DELETE" Then Rows(i & ":" & i).Delete i = i - 1 End If Next i End Sub On each of the three tabs (Current Portfolio, Rebalance and New Portfolio) we need to be able to extract the values to a new workbook, delete blank spaces and keep conditional formatting (Cell Colours) when we sort the data. This used to be done via a button which ran a macro on each of the three pages. This should only be a quick job for the right person.

JavaScript

Kitambulisho cha mradi: 14555779

Kuhusu mradi

4 mapendekezo

Mradi wa mbali

Inatumika 7 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

4 wafanyakazi huru wana zabuni kwa wastani $28 AUD kwa kazi hii

@mohamedkaram93

Hi there! I will be happy to help you with that simple one. The script will be called using a button just like in Excel and actually Google Script offers a better solution than using a button. Relevant Skills and Experience Experienced in writing Google Apps Script for nearly all Google Apps, Proposed Milestones $30 AUD - Complete the project

$30 AUD ndani ya siku 0

5.0

(31 hakiki)

5.3

@Jobsatisfied

I am able to work on your requirement full time and get it done quickly. I have excel vba programming experience and have javascript google script experience. Relevant Skills and Experience Based on your code, you need to copy and paste special values function, delete rows with cells "delete". Proposed Milestones $15 AUD - Testing on script for 1 worksheet. $10 AUD - Deliver rest of the script for the other worksheet

$25 AUD ndani ya siku 3