Code a simple script for google sheets:
[login to view URL]
(create copy of the file to edit on your drive)
In the INPUTs sheet you got cell B18 "Descuento Ciego" as a manual input. When this cell is changed column J4:J7 "Valor Total" is affected.
We need a script that loops through B18 values to find 4 values so that Valor Total = Adjusted ppl (column I) in a way that
- J4 = I4
- J5 = I5
- J6 = I6
- J7 = I7
Then the macro will paste the given "Descuento ciego" value in cell B18 for each scenario and paste it in the "Descuento" column K4:K7 (highlighted greed).
The values currenty in column K are an approximation for illustrating the output. Macro should find exact value
5 фрилансеров(-а) в среднем готовы выполнить эту работу за $31
Hi, I have extensive work experience working with MS Excel VBA, Macros and Formulas. I have gone through the requirement and can quickly provide the solution as required. Thanks.
Hi There, I am very much interested in doing this project. I am new here but having a very rich experience in this field. Please give me a chance to work for you. Please. Thanks