google sheets - how to - Automatically Move Row down Based On Dropdown

[zenki1]

Hi, I am new to Google Sheets, Can someone help me with the code to move the entire row to an other certain row if I change the Column F to 'done'.

Example : if i change F3 to 'done' then entire row 3 will be automatically moved to after row 40
Note : Filter function did not work in this case for us ^^ i tried macro but... had to active macro manually ^^ , it would be great if a script that help to do it automatically, thanks for any help

[MattDV]

You will have to implement onEdit function to be executed anytime that you make a change into Google Sheet.

Then you will have to validate if the value set in F3 is Done by using an IF statement with getvalue of the F3 Cell 

If that's TRUE,  get the entire Datarange and and move it to specific area