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

$10-30 AUD

Closed

Posted

almost 7 years ago

$10-30 AUD

Paid on delivery

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

Project ID: 14555779

About the project

4 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

4 freelancers are bidding on average $28 AUD for this job

@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 in 0 day

5.0

(31 reviews)

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 in 3 days