Завершено

Google sheets macro - App Script

Code a simple script for google sheets:

[login to view URL]

(create copy of the file to edit on your drive)

Description

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

Квалификация: Excel, Excel Macros, Javascript, Visual Basic

Показать больше script code google earth picture excel, google translate script code, google script code therapist, google sheets script examples, failed to save macro google sheets, google apps script tutorial pdf, google apps script course, google sheets macro example, google sheets macro button, google sheets macros examples, google sheets import script, place company location google map java script code, script code custom markers google maps, string app script google, script code twitter facebook google website, google calendar android app source code, We need a 4 sided design for a standard half gallon carton (Evergreen packaging 3.764\ x 3.764\ ), google live channels app source code, google sheets to calendar script, google sheets macro language

О работодателе:
( 3 отзыв(-а, -ов) ) Ciudad de México, Mexico

ID проекта: #19090479

Поручен:

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Больше

$35 USD за 1 день
(676 отзывов(-а))
8.4

5 фрилансеров(-а) в среднем готовы выполнить эту работу за $31

nvchien94

Hello there, I am an Google script coder and I can support you in this file. I did many gg app scripts in previous project. I can do it very quick and complete for you in 30 mins. Please contact and I can start rig Больше

$20 USD за 1 день
(51 отзывов(-а))
4.6
Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T Больше

$30 USD за 0 дней(-я)
(29 отзывов(-а))
4.0
sg99

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.

$30 USD за 0 дней(-я)
(1 отзыв)
1.0
IbexEnterprises

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

$25 USD за 1 день
(2 отзывов(-а))
0.5