Find Jobs
Hire Freelancers

Write small code in Google scripts

₹600-1500 INR

Imekamilika
Imechapishwa over 6 years ago

₹600-1500 INR

Kulipwa wakati wa kufikishwa
I use the below code in VBA in excel but i want the same function to be written in google scripts which i want to use in google sheets. Code as below : Private Sub Worksheet_Change(ByVal Target As Range) Dim temp As Range, max As Range, min As Range Set temp = Range("A2") Set max = Range("B2") Set min = Range("C2") If Not Intersect(temp, Target) Is Nothing Then max = [login to view URL](Target, max) min = [login to view URL](Target, min) End If End Sub Value of A2 keeps changing with time,therefore, What this code does is It records the Highest and Lowest Value from cell A2 to B2 and C2 respectively.
Kitambulisho cha mradi: 15167763

Kuhusu mradi

4 mapendekezo
Mradi wa mbali
Inatumika 7 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
Imetolewa kwa:
Picha ya Mtumiaji
Hi, my name is Kaio Stricker and I would like to help you in your task. Relevant Skills and Experience Plenty Excel experience, already know how to solve your problem. If you choose me, I'll send you the solution as soon as possible! Proposed Milestones ₹850 INR - Delivery of the fully working code.
₹850 INR ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
4 wafanyakazi huru wana zabuni kwa wastani ₹1,050 INR kwa kazi hii
Picha ya Mtumiaji
I have excellent command on Google Sheets and MS Excel. I have completed complex projects before involving Macros. You can see the reviews of the same in my profile Relevant Skills and Experience I know how to execute code in Google Sheets when a value changes and also get the highest and lowest values in a sheet / column Proposed Milestones ₹1300 INR - Completion of work
₹1,300 INR ndani ya siku 1
4.8 (7 hakiki)
3.9
3.9
Picha ya Mtumiaji
‌Hi I am vba developer since 2012 with experience in writing macros for ms excel, word, PowerPoint and ms access. Also i have develop application on vb6. actually there is some issues in chat.
₹1,450 INR ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
This will done in one day(less than 24hrs). Relevant Skills and Experience Have created many script Proposed Milestones ₹600 INR - work complete You will share existing googlesheet or i create new with script or email you the code of script?
₹600 INR ndani ya siku 1
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya INDIA
delhi, India
0.0
0
Njia ya malipo imethibitishwa
Mwanachama tangu Ago 6, 2016

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.