Need simple app script for google sheets

€8-30 EUR

完了済み

投稿日:

6年以上前

€8-30 EUR

完了時にお支払い

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

プロジェクト ID: 15828629

プロジェクトについて

1個の提案

リモートプロジェクト

アクティブ 6年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@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 3日以内