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!
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