Find Jobs
Hire Freelancers

custom script for google sheets that automatically updates one spreadsheet when other spreadsheet is modified

$10-30 USD

종료됨
게시됨 5년 이상 전

$10-30 USD

제출할때 지불됩니다
I have two spreadsheets on the same google drive account. "Spreadsheet A" contains my shop orders, one order per row. Sometimes I will edit manually some of the cells for each order. I need a google apps script that automatically copies all the modifications on 4 columns of the "spreadsheet A" and apply the same modifications on "spreadsheet B". The "spreadsheet B" also contains one order per row but some columns are different and data is organised in a different way. There is a column named "order ID" that is used on both spreadsheets, it can be used to connect both spreadaheets and identify which row must be updated. The script should identify what rows were modified on spreasheet A and find the row on spreadsheet B that refers to the same order based on the value of the column "order ID". These two spreadsheets are separated files that cannot be combined into one single spreadsheet. They must be keept as separated files.
프로젝트 ID: 18137250

프로젝트 정보

14 제안서
원격근무 프로젝트
활동 중 5년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
14 이 프로젝트에 프리랜서들의 평균 입찰은 $31 USD입니다.
사용자 아바타
Hello. I can help you with writing Google Apps Script to update a spreadsheet based on other spreadsheet edit on same drive. We can discuss further details on chat.
$49 USD 0일에
5.0 (126 건의 리뷰)
8.3
8.3
사용자 아바타
Hi I am Mokshith Expertised in Web Scraping & VBA Macros.. i can do any excel automation tasks, bulk email handling using outlook,File Conversion i can "SCRAPE" any website either static or dynamic also.. & in addition to VBA i can do Python programming, Google Apps Script coding, Wordpress Developement, HTML, VB.Net, PHP, Javascript & css, Ecommerce Wordpress Sites Developement. I will do this task in a Day Only.. Thankyou~
$25 USD 1일에
5.0 (22 건의 리뷰)
4.3
4.3
사용자 아바타
I have been working with G-Suite for a while now, and have managed to pull of really complicated relations between sheets quite efficiently. I realise your requirements are quite modest and i am very confident about getting this task done in just a few hours. I will be glad to help you out with this.
$25 USD 1일에
5.0 (3 건의 리뷰)
3.0
3.0
사용자 아바타
hello sir i will do this project for you professionally as you mentioned in detail kindly send me your project detail so we can discuss further r
$10 USD 1일에
3.8 (1 건의 리뷰)
2.0
2.0
사용자 아바타
Hi. I am experienced with Javascript and familiar to Google Apps Script. I can solve your problem that meets your requirements in short time.
$30 USD 2일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hi, I can definitely help you deal with your Excel data. We can use formula to update other sheet automatically. I have work as an administrative specialist for more than 10 years. I am a true all-around assistant with the ability to multitask & handle all aspects of business. While working for more than 10 years in Meralco Company, I was able to master different office applications specially in making report in Excel spreadsheet. I've studied the basic VA skills in depth: -Email Management -Calendar Management -Office Applications -Internet Research -WordPress -Social Media Management My skills include (but not limited to) MS Word, Power Point, Google sheets, Google Docs. I would love to learn more about your business so I can assist you best. Looking forward to hearing from you. Geraldine Esclamado
$25 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hello there, i would love to help you with this project as i had similar projects experience. I am G-Suite Developer where i use GAS to automate businesses redundant workflow by integrating our product.
$55 USD 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
This project is pretty easy for me i used to do this. Relevant Skills and Experience I used to do this nature of work.
$25 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
HI, I CLEARLY UNDERSTAND YOUR REQUIREMENT ITS 10 MINUTES JOB FOR ME. I CAN ALSO MAKE YOU UNDERSTAND FOR YOUR FUTURE REFERENCE THEN YOU CAN EDIT YOURSELF.
$25 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I can do this task quite easily I feel. Also, if you tell me the required situation would also help to add in more functionality (reasonably) at no extra cost.
$35 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (INDONESIA)
Lisboa, Indonesia
5.0
7
결제 수단 확인
10월 1, 2012부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.