asked on 12/30/2014

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

Spreadsheets Google Workspace

Last Comment

Saqib Husain

8/5/2015

ASKER CERTIFIED SOLUTION

Rgonzo1971

1/4/2015

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Saqib Husain

2/11/2015

ASKER

Hi, Rgonzo1971, sorry for being away.

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.

Rgonzo1971

2/15/2015

Cannot help further as my sheet continues to word perfectly
Sorry

Saqib Husain

3/4/2015

ASKER

Hi and sorry again. I need more time before testing.

You can post a reply to keep the clock ticking.

Saqib Husain

8/5/2015

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