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.
15 freelancers are bidding on average $31 for this job
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.
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"?
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.
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.
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.