My company need to automate some things in Google Spreadsheet, as confere if two informations of differents cell match, and if it happens do an action, pick data of a cell and search for the correspoding information in other spreadsheet, pick the data of the selected cells and search for same data in other spraedsheet and delete this datas in the other spreadsheet. Resumings are about 5 diferent fuctions, but all simple fuctions, i thing the person wich will do the work need to know create scripts in google spreadsheet.
I recorded this video to show what i need: [login to view URL]
And here is the link to the spreadsheet:
[login to view URL]