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.
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 in 1 day
0.0 (0 reviews)
0.0
0.0
4 freelancers are bidding on average ₹1,050 INR for this job
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
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.
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?