Fermé

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.

Compétences : Traitement de Données, Moteur Google App, Javascript

en voir plus : 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

Concernant l'employeur :
( 5 commentaires ) Lisboa, Indonesia

Nº du projet : #18137250

15 freelance font une offre moyenne de $31 pour ce travail

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 ( Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(347 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(65 Commentaires)
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"?

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(5 Commentaires)
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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0