Google sheets: Moving rows to other sheets using trigger
I found this edit-triggered routine from a website which works fine for inserting a comment in the edited cell. But when I modify the routine for myself the object e is not recognized at all.
Can someone do a routine for me which is activated as soon as the user enters a y in column H and moves that row (column A to column F) to the sheet whose name can be found in column G?
Here is the file
https://docs.google.com/spreadsheets/d/1yEDWuURRENO1wsG1XDoq18XjYTb7mbUKeViLe4S-1Mo/edit?usp=sharing
Can someone do a routine for me which is activated as soon as the user enters a y in column H and moves that row (column A to column F) to the sheet whose name can be found in column G?
Here is the file
https://docs.google.com/spreadsheets/d/1yEDWuURRENO1wsG1XDoq18XjYTb7mbUKeViLe4S-1Mo/edit?usp=sharing
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Cannot help further as my sheet continues to word perfectly
Sorry
Sorry
ASKER
Hi and sorry again. I need more time before testing.
You can post a reply to keep the clock ticking.
You can post a reply to keep the clock ticking.
ASKER
I am off that project now and may never get to use this. So shall close this as it did work the first time.
Thanks
Thanks
ASKER
I had tried this at that time and it worked. In fact, I had written a routine initially and it worked. Later the event did not fire. When I tried your routine later again the event did not fire. I have not been able to spend time on this which is why my response was delayed.
I wonder what is stalling the firing of the event.