Find Jobs
Hire Freelancers

Google sheets script to lock/protect rows based on value on another cell

$10-30 USD

Slutfört
Publicerad nästan sex år sedan

$10-30 USD

Betalning vid leverans
Hi, I have a expense report table that employees put their expenses. Employees have a full write permission to Column A,B,C,D,E,F and managers have full permission to the table. I need a script that once a manager put "approved" status on column H, the corresponding rows on column A,B,C,D,E,F should be locked for editing. In order to edit the approved cells, manager needs to change the "approved" status. You can see the sample sheet here: [login to view URL] Can anybody help me on this? Note: The freelancer should install the working script on the sample sheet that I have provided to get final approval. Thanks in advance,
Project ID: 17086709

Om projektet

8 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
This is the code for your work sheet Private Sub Worksheet_Change(ByVal Target As Range) If [login to view URL](2, 7).Text = ""X"" Then [login to view URL](Cells(3, 7), Cells(66, 7)).Locked = True Else [login to view URL](Cells(3, 7), Cells(66, 7)).Locked = False End If End Sub
$25 USD Om 1 dag
4,9 (6 omdömen)
2,1
2,1
8 frilansar lägger i genomsnitt anbud på $29 USD för detta uppdrag
Använd avatar
Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Regards, Nidhi
$25 USD Om 1 dag
4,9 (121 omdömen)
6,4
6,4
Använd avatar
Hello, I went thru the project description. This can be done by today Kindly check my past projects and reviews Today can start. Looking forward to hearing from you Thanks Regards Thushara
$30 USD Om 1 dag
5,0 (29 omdömen)
4,4
4,4
Använd avatar
Dear Client, Today I have found this job post on Freelancer, and I'm interested in your job Post involving the need of a data entry assistant I have good experience In data entry, web research, Image Conversion and MS Office as I have worked before in my past outside Freelancer as a data entry for a carrier website for 4 months. My typing speed is more than 50 words per minute. Q#1: Can anybody help me on this? Ans: Yes, I do this in 3 hours. I know that what you want. I believe my skills would be Ideal for your project. Incomplete this job within the required time period. Moving forward, I can dedicate 30 hour/week for your job, and my daily hours are negotiable. I'm very excited to offer my services for your job. Please feel free to contact me directly to discuss this position further. I am mostly available online on Freelancer. We can discuss there in detail in a quick way if you are interested. Regards, Ali Ghazanfar
$25 USD Om 1 dag
4,8 (11 omdömen)
2,9
2,9
Använd avatar
What is the deadline for this job? And am available to work on your project Data entry am conversant
$30 USD Om 1 dag
0,0 (0 omdömen)
0,0
0,0
Använd avatar
hi this is vidya i have 3 years experience in quallity analyst ill give 100% qualityas soon as possible thanks & regards
$40 USD Om 1 dag
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för TURKEY
Istanbul, Turkey
5,0
11
Verifierad betalningsmetod
Medlem sedan okt. 14, 2012

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.