Completed

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

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,

Skills: Data Entry, Data Processing, Excel, Google App Engine, Scripting

See more: conditional locking of cells in google sheets, google sheets conditional protection, google sheets lock formatting, google script lock cells, auto-lock-cells-after-data-entry google sheets, google sheets lock conditional formatting, google script protect range, lock a cell once data is entered google sheets, \ google sheets\ script, \ google sheets script\ , i am looking for someone to write a google apps script in google sheets, google apps script for sheets, script update cell google sheets, add row excel based value, excel add row based cell value

About the Employer:
( 10 reviews ) Istanbul, Turkey

Project ID: #17086709

Awarded to:

donSene

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 ActiveShe More

$25 USD in 1 day
(0 Reviews)
0.0

9 freelancers are bidding on average $30 for this job

Nidhijain123

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 ge More

$25 USD in 1 day
(100 Reviews)
5.9
nelumindralal

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 in 1 day
(18 Reviews)
4.0
tony2410

What is the deadline for this job? And am available to work on your project Data entry am conversant

$30 USD in 1 day
(0 Reviews)
0.0
$35 USD in 1 day
(0 Reviews)
0.0
mohdsalman939

I am an Accountant.I am looking for a position that would recognize my talent and provide me an opportunity to put in my best for the benefit of the [login to view URL] my work experience I have versatile Expertise working on m More

$25 USD in 1 day
(0 Reviews)
0.0
Vidyasree123

hi this is vidya i have 3 years experience in quallity analyst ill give 100% qualityas soon as possible thanks & regards

$40 USD in 1 day
(0 Reviews)
0.0
AlieGhazanfar

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 More

$25 USD in 1 day
(0 Reviews)
0.0
$34 USD in 1 day
(1 Review)
0.1