Closed

Google sheet and appscript expert

Hi, I need to someone who can do below:

Trigger 1

if week = 2 (Week number is on CellQ4)

1. Looks through T3:T53 for the sheet name

2. VLOOKUP(U3 to U53,Indirect(CONCAT($T$4:$T$53,"!$A$2:$K$129")

3. Changes the value of what was Vlookuped to the value on W3:W53 to the Sheet indicated on T108:T157

if week = 1 (Week number is on CellQ4)

1. Looks through AB3:AB53 for the sheet name

2. VLOOKUP(AC3 to AC53,Indirect(CONCAT($AB$4:$AB$53,"!$A$2:$K$129")

3. Changes the value of what was Vlookuped to the value on AE3:AE53 to the Sheet indicated on AB108:AB157

Trigger 2

if week = 2 (Week number is on CellQ4)

1. Looks through T108:T157 for the sheet name

2. VLOOKUP(U108 to U157,Indirect(CONCAT($T$108:$T$157,"!$A$132:$K$228")

*If Y108Y157 is not equal to Zero

3. Changes the value of what was Vlookuped to the value on W108:W157 to the Sheet indicated on T108:T157

*If Y108:Y157 =Zero

3 Copies Value of U108:U157 to A229:A248 and X108:X157 to I229:I248 of the Sheet indicated on T108:T157

Checks value of V108:V157

4.1 If V108:V157 = "PO Hse" copy value in W108:W157 to D229:D248 of the sheet indicated on T108:T157

4.1 If V108:V157 = "PO Crt" copy value in W108:W157 to E229:E248 of the sheet indicated on T108:T157

4.1 If V108:V157 = "PO Left" copy value in W108:W157 to G229:G248 of the sheet indicated on T108:T157

4.1 If V108:V157 = "PO in" copy value in W108:W157 to K229:K248 of the sheet indicated on T108:T157

if week = 1 (Week number is on CellQ4)

1. Looks through AB108:AB157 for the sheet name

2. VLOOKUP(AC108 to AC157,Indirect(CONCAT($AB$108:$AB$157,"!$A$132:$K$228")

*If AG108:AG157 is not equal to Zero

3. Changes the value of what was Vlookuped to the value on AE108:AE157 to the Sheet indicated on AB108:AB157

*If AG108:AG157 =Zero

3 Copies Value of AC108:AC157 to A229:A248 and AF108:AF157 to I229:I248 of the Sheet indicated on AB108:AB157

* Checks for the next empty row so that past data will not be deleted

Checks value of AD108:AD157

4.1 If AD108:AD157 = "PO Hse" copy value in AE108:AE157 to D229:D248 of the sheet indicated on AB108:AB157 (Same row with step 3)

4.1 If AD108:AD157 = "PO Crt" copy value in AE108:AE157 to E229:E248 of the sheet indicated on AB108:AB157 (Same row with step 3)

4.1 If AD108:AD157 = "PO Left" copy value in AE108:AE157 to G229:G248 of the sheet indicated on AB108:AB157 (Same row with step 3)

4.1 If AD108:AD157 = "PO in" copy value in AE108:AE157 to K229:K248 of the sheet indicated on AB108:AB157 (Same row with step 3)

If you think you can make a script for that, contact me.

Skills: Google Sheets, Javascript, VBScript

See more: google maps api expert, salary google certified ppc expert, google map api expert, google maps javascript expert, google base api expert, google maps listing expert, google shopping cart expert, google map listing expert, google adwords ppc expert jobs, find google certified marketing expert, find google maps listing expert, google ad manager expert, google base feed expert, google tile layer expert, query excel sheet excel expert needed, google map programmer expert, google apps email expert, google checkout integration expert, google shopping optimization expert, google local listing expert

About the Employer:
( 9 reviews ) London, United Kingdom

Project ID: #24456918

16 freelancers are bidding on average $127 for this job

BaNgan

Hello I can do that kind of script for you, please discuss some questions: - The trigger you want, will it is a time-based trigger or onEdit/onChange trigger when user edit a cell? - May you share the current template More

$100 USD in 2 days
(348 Reviews)
7.4
kanwalrafique

Hello, I'm a Google Apps Script developer. I have experience in coding Google Apps Scripts for Google Sheets as well as other G Suite apps. I can implement all the steps you've listed in your project description. But a More

$250 USD in 10 days
(27 Reviews)
5.5
NaliRaz

Hi, Feel free to contact me over chat so we can discuss about your project and how I plan to achieve it. Best regards, Naly

$90 USD in 3 days
(6 Reviews)
3.8
nemanjadj20

Hello? I have worked on Google App/Script projects to what you are looking for, and I am confident I can exceed your expectations. Thank you for your time. I have attached samples of work very similar to what you ar More

$155 USD in 3 days
(2 Reviews)
3.2
IvanCoder204

Hi, Nice to meet you I am good at google sheet script I have over 10 years of experience in software development I can do it perfectly Best regards.

$150 USD in 2 days
(3 Reviews)
3.3
rinabuoy13

Hello, I am an independent, experienced excel / vba / app script expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.

$100 USD in 7 days
(3 Reviews)
3.0
cziner

Hi! So, you need to test different ranges against multiple criteria and based on test results, you need to copy values between (one-way) corresponding ranges of different sheets. I’ve the experience in developing simil More

$100 USD in 5 days
(1 Review)
2.1
royalcalif

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer, Basically the Google sheets is running by Java script. So we have some knowledge in the JS. I have More

$30 USD in 7 days
(2 Reviews)
2.0
anviverma111

HI I am experienced in Javascript VBScript Google Sheets etc I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your reply

$140 USD in 7 days
(1 Review)
1.6
khr92

I am experienced Google sheet script, formula developer. I can apply vlookup(), if() and other useful function with script to solve your problem with requirements and update Google sheet cell values dynamically.

$200 USD in 3 days
(2 Reviews)
1.6
legioner80ru

hello, thank you for your interest in my profile. I am ready to implement the project ASAP best regards, dima

$111 USD in 3 days
(2 Reviews)
1.3
World9174

Need growing for your business via Online? I'm pretty happy to bid on this interesting project. I read your description carefully and I think that I am the developer you are looking for and are suitable for this task. More

$140 USD in 2 days
(1 Review)
0.4
kirilnberezebko

Hi. I have read your job description carefully. so your job is very interested for me. I can start just now and I can do your project perfectly. If you give me a chance, you will get good result. I hope to discuss more More

$100 USD in 3 days
(0 Reviews)
0.0
peacemarketing

Hi, I'm a full-stack developer with over 10 years of experience. I have a strong background in Google Sheet scripts and can help you on this project. Would love to hear more about the project and how we can work More

$155 USD in 3 days
(0 Reviews)
0.0
salmanullahbaig

Hi, I can create a script for the your task. I have two year experience in python and I'm confident that I can create a script for the project better. would like to discuss more. Thanks

$144 USD in 5 days
(0 Reviews)
0.0
MSyda

Hi there! I have enough coding experience to write these scripts, and I can do it in 3 days. I can offer you good quality work, as I am constantly working on such tasks and low cost, because my goal now is to get more More

$60 USD in 3 days
(0 Reviews)
0.0