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?:)