custom script for google sheets that automatically updates one spreadsheet when other spreadsheet is modified
Budget $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.
15 freelancers are bidding on average $31 for this job
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
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 More
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
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 am experienced with Javascript and familiar to Google Apps Script. I can solve your problem that meets your requirements in short time.
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.
