Write Custom Google Sheets Script (JavaScript)

Dokončeno Zveřejněno před 6 lety K zaplacení v momentě doručení

£20-250 GBP

K zaplacení v momentě doručení

Dokončeno K zaplacení v momentě doručení

I have a large spreadsheet designed already. Have made a shell spreadsheet with instructions, specific layout and details. The layout must not be changed.

https://docs.google.com/spreadsheets/d/1l5-pBB0zskZv5C3aOOmEoVWkHTPj_g0i7qY-TBcqU9c/edit#gid=1956429517

Need a custom formula to copy specified columns and rows, of a certain type (excluding rows with zero value/blank and subtotals/section headings) from one specified sheet to specified columns in specified rows on another.

Will have an input sheet giving:

Column numbers to Copy From > column numbers to Copy To

Copy From Sheet Name

Copy From number of rows

Copy To Sheet Name

Copy To Area Selector

Copy To Area Row Start/Finish Numbers

There are columns which shouldn't be copied, and columns which shouldn't be overwritten.

This should be a menu executed command with a custom menu:

Budget>Copy Estimate Selected to Budget Area Selected

Message: Are you sure you want to copy from (Sheet Name) to (Area Name)

Yes/No

Cheers,

Jeremy

Excel Google App Engine Google Chrome JavaScript

Identifikační číslo projektu: #16596000

O projektu

15 nabídek Projekt na dálku Aktivní před 6 lety

Máte zájem si vydělat?

Výhody zveřejňování nabídek na Freelanceru

Zadejte váš rozpočet a dobu trvání práce
Nechte si zaplatit
Ve zkratce popište svůj návrh
Založení účtu a zveřejňování nabídek na projekty je zdarma

Uděleno uživateli:

Profilový obrázek uživatele cziner
cziner

Good news! I’ve already created the Apps Script based custom Copy-Paste utility what you need. I think, I’ve followed everything you described in this project description and in your shared spreadsheet. 1. My copy-pa Další

£100 GBP za 10 dní
(9 recenzí)
4.8

15 Freelnceři na tento projekt zveřejňují nabídky v průměru £148

Profilový obrázek uživatele Gaosong2017
Gaosong2017

Hello, I read your whole proposal, and thanks for your post on my good experience. This is very good job for me. So I think I can do this in high quality. My releavant skill is: Excel, Google App Engine, Google Ch Další

£150 GBP za 3 dní
(52 Recenzí)
6.3
Profilový obrázek uživatele satishtl
satishtl

- Went through the spreadsheet and the Code selector tab and the Budget sheet. - Based on the menu item click can get the data rows/column data copied based on the conditions, that some can be overwritten, copied. - Další

£100 GBP za 3 dní
(48 Recenzí)
6.0
Profilový obrázek uživatele ioanaprof
ioanaprof

Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in G Suite (Google Apps Script and Google Docs). Please, take a look at my portfolio in my profile. Can meet all your requirements. Thank Další

£50 GBP za 4 dní
(40 Recenzí)
5.3
Profilový obrázek uživatele linbenrong
linbenrong

Dear Client. I read your post project carefully. It is necessary to use only simple javascript parse and convert function and engine. There are many my perfect sample ofr it. I can start right now. let's save time Další

£150 GBP za 1 den
(16 Recenzí)
5.5
Profilový obrázek uživatele sagarsureja3
sagarsureja3

Hi there, We are an expert with writing JavaScript on Google Spreadsheet, we can make the sheet as per your given requirements.

£166 GBP za 3 dní
(5 Recenzí)
3.6
Profilový obrázek uživatele ramtricky
ramtricky

Yes Cheers, Jeremy. I’m very competent and can reach your expectations.I have great experience in Javascript which matches your criteria and very comfortable in working with you. If you give a chance I can fix Další

£277 GBP za 0 dní
(6 Recenzí)
3.3
Profilový obrázek uživatele arjun366333
arjun366333

Ready to start the work to Write Custom Google Sheets Script/JavaScript, We can discuss more over chat, Thanks Arjun S.

£200 GBP za 3 dní
(3 Recenzí)
4.9
Profilový obrázek uživatele madalinac8
madalinac8

Hello, Jeremy, I can provide you a script that will copy the cells from an "Estimate" sheet to a "Budget" sheet based on the conditions specified on "CODE SELECTOR". You can check some of my previous work on my p Další

£90 GBP za 4 dní
(2 Recenzí)
1.3
Profilový obrázek uživatele AqeelSheikh1
AqeelSheikh1

Hi I am Professional in Market Searching, MS Office and in Data Mining also done a lots of jobs regarding this on another platforms like fiver and Upwork etc. I will provide you error free work. I also provide you sa Další

£55 GBP za 3 dní
(0 Recenzí)
1.6
Zadejte podobný projekt