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 freelance font une offre moyenne de $31 pour ce travail
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
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"?
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
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
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
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
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
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.
This project is pretty easy for me i used to do this. Relevant Skills and Experience I used to do this nature of work.
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.