Write Custom Google Sheets Script (JavaScript)

Completed Posted 6 years ago Paid on delivery

£20-250 GBP

Paid on delivery

Completed Paid on delivery

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

Project ID: #16596000

About the project

15 proposals Remote project Active 6 years ago

Looking to make some money?

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

Awarded to:

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 More

£100 GBP in 10 days

(9 Reviews)

4.8

15 freelancers are bidding on average £148 for this job

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 More

£150 GBP in 3 days

(52 Reviews)

6.3

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. - More

£100 GBP in 3 days

(48 Reviews)

6.0

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 More

£50 GBP in 4 days

(40 Reviews)

5.3

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 More

£150 GBP in 1 day

(16 Reviews)

5.5

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

(5 Reviews)

3.6

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 More

£277 GBP in 0 days

(6 Reviews)

3.3

arjun366333

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

£200 GBP in 3 days

(3 Reviews)

4.9

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 More

£90 GBP in 4 days

(2 Reviews)

1.3

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 More

£55 GBP in 3 days

(0 Reviews)

1.6

Post a project like this