Closed

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

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.

Skills: Data Processing, Google App Engine, Javascript

See more: custom marker google map script, link excel sheets automatically updates, script code custom markers google maps, how to customize google sheets, how can i get google sheets to auto update a reference to another sheet?, google sheets script editor, google sheets script, google sheet custom formula, google sheets custom function, variables in google sheets, google script variable types, script google custom search api, service automatically updates google base, imacro script google spreadsheet, looking basic script automatically updates store categories, script update cell google sheets, historical data script google spreadsheet, email reminder script google spreadsheet, google apps script for sheets, i am looking for someone to write a google apps script in google sheets

About the Employer:
( 5 reviews ) Lisboa, Indonesia

Project ID: #18137250

15 freelancers are bidding on average $31 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$50 USD in 0 days
(347 Reviews)
7.7
celalaybar

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 in 0 days
(65 Reviews)
5.8
jungleru

Hello, I can create this app But I need to know what a column need to change? For example you changed on shreadsheet "A" column "xxx" What column need to change on spreadsheet "B"? Same "xxx" or "yyy"?

$30 USD in 1 day
(14 Reviews)
5.3
Mokshith30

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

$25 USD in 1 day
(5 Reviews)
2.2
cziner

Hello there! I can easily do the job, with your full satisfaction. Here is demo of a similar project I completed in January of this year: -> Automated Order Placing cum Payment Management System — [login to view URL] More

$25 USD in 3 days
(1 Review)
2.2
murtaza896

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 More

$25 USD in 1 day
(1 Review)
2.0
akkijhamta

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 in 1 day
(1 Review)
1.8
alessandro33

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 in 2 days
(0 Reviews)
0.0
Gerdin2

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

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

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 in 3 days
(0 Reviews)
0.0
seanrich2019

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 in 1 day
(0 Reviews)
0.0
Bhanucreation

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 in 1 day
(0 Reviews)
0.0
$30 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0
subodhmahajan

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 in 1 day
(0 Reviews)
0.0