Need simple app script for google sheets

€8-30 EUR

Completed

Posted

over 6 years ago

€8-30 EUR

Paid on delivery

Hi! I basically need a script that somehow does exactly the same as the VBA-code in the excel-sheet attached, except I need this as an app script for a google sheet that looks alike (the form controls are replaced with formulas that changes the values in cell A1 and A2 in the google sheet). The VBA-code is written by me (super amateur) so maybe write the code a bit more neatly than I did.. No problem adding more rows etc. if necessary to make this work as long as they are hidden (row 1 and 2 in the attachment are supposed to be hidden..). I'd like the code, and an explaination of how to make it work in my google sheet. Somebody who can help me?:) Thanks!

JavaScript

Scripting

Project ID: 15828629

About the project

1 proposal

Remote project

Active 6 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

Awarded to:

@insidenetsoft

Hello, We could create some buttons in the top of the google sheet in order to hide or show the needed columns, carefully respecting the rules you’ve already defined for the .xlsm file. Would you be interested to see a demo? I could start the work imediately. My last VBA work includes: - tool that automatically prepares PDF invoices using complex calculations - tool that send emails automatically for each team leader containing only his team members+custom attachment - import of one excel file within another in order to be processed following some configurable parameters - vba tools with multiple forms, transfer data between windows forms - data processing and reconciliation Don’t hesitate to contact me on chat to discuss the solutions for your project. Regards, Marius

€50 EUR in 3 days