Đã hoàn thành

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

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

[url removed, login to view] = False

Sheets("New Portfolio").Copy

[url removed, login to view]

[url removed, login to view]

[url removed, login to view] Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

Columns("S:AZ").Select

[url removed, login to view] Shift:=xlToLeft

[url removed, login to view](Array("Button 1")).Select

[url removed, login to view]

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.

Kĩ năng: Javascript

Xem nhiều hơn: i am looking for someone to write a google apps script in google sheets, basic cart script php, write script searching website, visual basic for apps, googlescripts, basic submit script, write script, write script search website, write script read web pages, visual basic login script, basic html script, write script redirect linux, write script list domain users login days months, visual basic find script, user basic upload script, write script sql, write script automatically reset dsl modem

Về Bên Thuê:
( 1 Nhận xét ) Sydney, Australia

ID dự án: #14556067

Được trao cho:

ketas

Dear, I have experience working with both Google Script & VBA on MS Excel. So , I could help you to finish this request in a short time. Regards Relevant Skills and Experience Google Script / VBA Proposed Milestone Thêm

$50 AUD trong 0 ngày
(0 Đánh Giá)
0.0

10 freelancer đang chào giá trung bình $60 cho công việc này

$25 AUD trong 1 ngày
(2 Nhận xét)
2.6
nmsandroid

i have already worked with Google spreadsheet. So it will not be much difficult for me.

$55 AUD trong 1 ngày
(1 Nhận xét)
2.1
$25 AUD trong 100 ngày
(1 Nhận xét)
0.8
$257 AUD trong 1 ngày
(0 Nhận xét)
0.0
immy143

A proposal has not yet been provided

$25 AUD trong 1 ngày
(0 Nhận xét)
0.0
ArchAndroid

Hey there! I'd love to turn your Excel VBA macro into a Google App Script for Sheets. I have experience in both platforms and would be happy to discuss it with you. Relevant Skills and Experience I have nine years' Thêm

$50 AUD trong 2 ngày
(0 Nhận xét)
0.0
Ranajoyfreelance

Dear Hiring Manager, Thanks for your time and [login to view URL] for your RESPONSE. Thanks, Ritika Relevant Skills and Experience Dear Hiring Manager, Thanks for your time and consideration. Thêm

$25 AUD trong 1 ngày
(1 Nhận xét)
0.0
surangs

Hi, I can do this project accurately and deliver in few days..................................................................

$30 AUD trong 2 ngày
(0 Nhận xét)
0.0
tsebro

Hello! I would like to help you with a script. As for me, I am professional Front-End Developer and co-owner of a web-development team with a 17 years experience in Web Development, especially in HMTL/CSS/JavaScrip Thêm

$54 AUD trong 1 ngày
(0 Nhận xét)
0.0